Re: ALTER SEQUENCE

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER SEQUENCE
Date: 2003-03-18 00:26:34
Message-ID: 200303180026.h2I0QYB00611@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches


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(at)rbt(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Calvin Chin 2003-03-18 01:13:32 Unsubscribe ?
Previous Message Bruce Momjian 2003-03-18 00:25:36 Re: [GENERAL] postgres error reporting

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-18 00:40:39 Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Previous Message Peter Eisentraut 2003-03-18 00:24:27 Re: Roadmap for FE/BE protocol redesign

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-03-18 00:29:59 Re: psql patch for datestyle
Previous Message Bruce Momjian 2003-03-18 00:26:15 Re: hashed crosstab