Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] ALTER SEQUENCE

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-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



In response to

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group