Re: [PATCHES] ALTER SEQUENCE - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PATCHES] ALTER SEQUENCE
Date
Msg-id 009801c2e1f0$099908a0$6500a8c0@fhp.internal
Whole thread Raw
Responses Re: [PATCHES] ALTER SEQUENCE
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: [PATCHES] XML ouput for psql
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: problem importing languages in CVS tip