From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Rod Taylor" <rbt(at)rbt(dot)ca> |
Cc: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] ALTER SEQUENCE |
Date: | 2003-03-04 01:47:37 |
Message-ID: | 009801c2e1f0$099908a0$6500a8c0@fhp.internal |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-patches |
Hey, with this new ALTER SEQUENCE patch, how about this for an idea:
I submitted a patch to always generate non-colliding index and sequence
names. Seemed like an excellent idea. However, 7.3 dumps tables like this:
CREATE TABLE blah
a SERIAL
);
SELECT SETVAL('blah_a_seq', 10);
Sort of thing...
How about we add a new form to ALTER SEQUENCE <sequence> ...?
ALTER SEQUENCE ON blah(a) CURRVAL 10.... (or whatever the syntax is)
or even
ALTER SERIAL ON blah(a)...
Which would allow us to dump tables in an environment where you do now know
exactly what the generated name will be...
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Patterson | 2003-03-04 02:20:47 | two concurrency questions |
Previous Message | Stephan Szabo | 2003-03-04 01:43:00 | Re: almost there on a design |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-03-04 01:49:59 | Re: problem importing languages in CVS tip |
Previous Message | cbbrowne | 2003-03-03 23:57:26 | Re: [PATCHES] XML ouput for psql |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-03-04 01:54:49 | new format for describe (repost #2) |
Previous Message | cbbrowne | 2003-03-03 23:57:26 | Re: [PATCHES] XML ouput for psql |