diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-20 07:02:11 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-20 07:02:11 +0000 |
| commit | 5f65225fa37bd244ee5487448ac542b2b2f47296 (patch) | |
| tree | 6fa88eb46e3ff9c1fd9fbe2f1d47bbacba2ffbc7 /src/backend/tcop/postgres.c | |
| parent | 46bce088c19d0e20152bc9c5e25ce105cff4fa07 (diff) | |
| download | postgresql-5f65225fa37bd244ee5487448ac542b2b2f47296.tar.gz postgresql-5f65225fa37bd244ee5487448ac542b2b2f47296.zip | |
Todo items:
Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
Also updated create sequence docs to mention NO MINVALUE, & NO MAXVALUE.
New Files:
doc/src/sgml/ref/alter_sequence.sgml
src/test/regress/expected/sequence.out
src/test/regress/sql/sequence.sql
ALTER SEQUENCE is NOT transactional. It behaves similarly to setval().
It matches the proposed SQL200N spec, as well as Oracle in most ways --
Oracle lacks RESTART WITH for some strange reason.
--
Rod Taylor <rbt@rbt.ca>
Diffstat (limited to 'src/backend/tcop/postgres.c')
| -rw-r--r-- | src/backend/tcop/postgres.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/backend/tcop/postgres.c b/src/backend/tcop/postgres.c index ec717d8c122..dd2ed6e500c 100644 --- a/src/backend/tcop/postgres.c +++ b/src/backend/tcop/postgres.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/tcop/postgres.c,v 1.317 2003/03/10 03:53:51 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/tcop/postgres.c,v 1.318 2003/03/20 07:02:10 momjian Exp $ * * NOTES * this is the "main" module of the postgres backend and @@ -1789,7 +1789,7 @@ PostgresMain(int argc, char *argv[], const char *username) if (!IsUnderPostmaster) { puts("\nPOSTGRES backend interactive interface "); - puts("$Revision: 1.317 $ $Date: 2003/03/10 03:53:51 $\n"); + puts("$Revision: 1.318 $ $Date: 2003/03/20 07:02:10 $\n"); } /* @@ -2381,6 +2381,10 @@ CreateCommandTag(Node *parsetree) tag = "CREATE SEQUENCE"; break; + case T_AlterSeqStmt: + tag = "ALTER SEQUENCE"; + break; + case T_RemoveAggrStmt: tag = "DROP AGGREGATE"; break; |