Thread: ALTER SEQUENCE
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> PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment
Hi, I have sent in a few patches in the last couple of days (and resent) and they haven't appeared on the lists - what's going on? Chris
I think the mail server was busted over the last couple of days (Thursday till Sunday afternoon). Read archives of -hackers, you'll see there were a few conversations going on that were never actually distributed. Anyway, nothing wrong with re-posting them. On Mon, 2003-03-03 at 02:06, Christopher Kings-Lynne wrote: > Hi, > > I have sent in a few patches in the last couple of days (and resent) and > they haven't appeared on the lists - what's going on? > > Chris -- Rod Taylor <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Rod Taylor wrote:
-- Start of PGP signed section.
> 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>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc
[ Attachment, skipping... ]
[ Attachment, skipping... ]
[ Attachment, skipping... ]
[ Attachment, skipping... ]
-- End of PGP section, PGP failed!
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Patch applied. Thanks. TODO updated. --------------------------------------------------------------------------- Rod Taylor wrote: -- Start of PGP signed section. > 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> > > PGP Key: http://www.rbt.ca/rbtpub.asc [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] [ Attachment, skipping... ] -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073