From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Add a RESTART (without parameter) option to ALTER SEQUENCE, |
Date: | 2008-05-16 23:36:05 |
Message-ID: | 20080516233605.DAB6D754C53@cvs.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Add a RESTART (without parameter) option to ALTER SEQUENCE, allowing a
sequence to be reset to its original starting value. This requires adding the
original start value to the set of parameters (columns) of a sequence object,
which is a user-visible change with potential compatibility implications;
it also forces initdb.
Also add hopefully-SQL-compatible RESTART/CONTINUE IDENTITY options to
TRUNCATE TABLE. RESTART IDENTITY executes ALTER SEQUENCE RESTART for all
sequences "owned by" any of the truncated relations. CONTINUE IDENTITY is
a no-op option.
Zoltan Boszormenyi
Modified Files:
--------------
pgsql/doc/src/sgml/ref:
alter_sequence.sgml (r1.19 -> r1.20)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_sequence.sgml?r1=1.19&r2=1.20)
truncate.sgml (r1.25 -> r1.26)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/truncate.sgml?r1=1.25&r2=1.26)
pgsql/src/backend/catalog:
pg_depend.c (r1.27 -> r1.28)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_depend.c?r1=1.27&r2=1.28)
pgsql/src/backend/commands:
sequence.c (r1.150 -> r1.151)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/sequence.c?r1=1.150&r2=1.151)
tablecmds.c (r1.253 -> r1.254)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.253&r2=1.254)
pgsql/src/backend/nodes:
copyfuncs.c (r1.393 -> r1.394)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c?r1=1.393&r2=1.394)
equalfuncs.c (r1.322 -> r1.323)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c?r1=1.322&r2=1.323)
pgsql/src/backend/parser:
gram.y (r2.614 -> r2.615)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.614&r2=2.615)
keywords.c (r1.195 -> r1.196)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/keywords.c?r1=1.195&r2=1.196)
pgsql/src/bin/pg_dump:
pg_dump.c (r1.491 -> r1.492)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.491&r2=1.492)
pgsql/src/include/catalog:
catversion.h (r1.460 -> r1.461)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.460&r2=1.461)
dependency.h (r1.34 -> r1.35)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/dependency.h?r1=1.34&r2=1.35)
pgsql/src/include/commands:
sequence.h (r1.40 -> r1.41)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/sequence.h?r1=1.40&r2=1.41)
pgsql/src/include/nodes:
parsenodes.h (r1.365 -> r1.366)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.365&r2=1.366)
pgsql/src/test/regress/expected:
sequence.out (r1.9 -> r1.10)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/sequence.out?r1=1.9&r2=1.10)
truncate.out (r1.13 -> r1.14)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/truncate.out?r1=1.13&r2=1.14)
pgsql/src/test/regress/sql:
sequence.sql (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/sequence.sql?r1=1.4&r2=1.5)
truncate.sql (r1.6 -> r1.7)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/truncate.sql?r1=1.6&r2=1.7)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-05-16 23:57:42 | pgsql: Fix declarations of pthread functions, missed in recent commit. |
Previous Message | Tom Lane | 2008-05-16 19:15:05 | pgsql: Reduce unnecessary PANIC to ERROR, improve a couple of comments. |