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

ALTER SEQUENCE

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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-03-03 05:16:36
Subject: Yet another open-source benchmark
Previous:From: Tom LaneDate: 2003-03-03 03:45:07
Subject: Re: CLUSTER loses nulls (was Re: [ADMIN] Still a bug in the VACUUM)

pgsql-patches by date

Next:From: Tom LaneDate: 2003-03-03 05:38:09
Subject: Re: PGRES_POLLING_ACTIVE is unused...
Previous:From: Joe ConwayDate: 2003-03-03 04:27:44
Subject: hashed crosstab

pgsql-general by date

Next:From: Dennis GearonDate: 2003-03-03 04:35:40
Subject: Re: selects possible in VALUES() claueses?
Previous:From: Bruno Wolff IIIDate: 2003-03-03 04:13:57
Subject: Re: selects possible in VALUES() claueses?

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