| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | ALTER SEQUENCE |
| Date: | 2003-03-03 04:34:23 |
| Message-ID: | 1046666063.26763.342.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-patches |
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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| Attachment | Content-Type | Size |
|---|---|---|
| patch | text/plain | 32.0 KB |
| sequence.sql | text/x-sql | 849 bytes |
| sequence.out | text/plain | 1.6 KB |
| alter_sequence.sgml | text/sgml | 8.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-03-03 04:35:40 | Re: selects possible in VALUES() claueses? |
| Previous Message | Bruno Wolff III | 2003-03-03 04:13:57 | Re: selects possible in VALUES() claueses? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-03-03 05:16:36 | Yet another open-source benchmark |
| Previous Message | Tom Lane | 2003-03-03 03:45:07 | Re: CLUSTER loses nulls (was Re: [ADMIN] Still a bug in the VACUUM) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-03-03 05:38:09 | Re: PGRES_POLLING_ACTIVE is unused... |
| Previous Message | Joe Conway | 2003-03-03 04:27:44 | hashed crosstab |