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

In response to

• Re: Off topic - was Re: [PATCHES] ALTER SEQUENCE at 2003-03-03 14:52:14 from Marc G. Fournier

Responses

• Re: [PATCHES] ALTER SEQUENCE at 2003-03-04 16:16:20 from Rod Taylor

pgsql-hackers by date

Next:	From: Christopher Kings-Lynne	Date: 2003-03-04 01:49:59
	Subject: Re: problem importing languages in CVS tip
Previous:	From: cbbrowne	Date: 2003-03-03 23:57:26
	Subject: Re: [PATCHES] XML ouput for psql

pgsql-patches by date

Next:	From: Christopher Kings-Lynne	Date: 2003-03-04 01:54:49
	Subject: new format for describe (repost #2)
Previous:	From: cbbrowne	Date: 2003-03-03 23:57:26
	Subject: Re: [PATCHES] XML ouput for psql

pgsql-general by date

Next:	From: Jeff Patterson	Date: 2003-03-04 02:20:47
	Subject: two concurrency questions
Previous:	From: Stephan Szabo	Date: 2003-03-04 01:43:00
	Subject: Re: almost there on a design