| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
| Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER SEQUENCE enchancement |
| Date: | 2003-11-24 06:20:41 |
| Message-ID: | 3FC1A339.3020507@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>Is there demand for this syntax:
>>
>>ALTER SEQUENCE ON table(col) CYCLE 100;
>>
>>It would allow us to become sequence-name independent...
>
>
> The above is an operation that would not help me a lot, but a way of
> performing currval() without knowing the sequence name would be good.
It will help in cases such as the 7.3-7.4 upgrade where a few of my
sequence names will get renamed because they maxed out at 32 characters...
I'll see about versions of currval() and nextval() that are sequence
name independent as well...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-11-24 06:36:57 | Re: Executable files in CVS |
| Previous Message | Dennis Bjorklund | 2003-11-24 06:11:59 | Re: ALTER SEQUENCE enchancement |