Re: pgsql-server/src/backend commands/sequence.c p ...

On Thu, 2003-02-13 at 02:21, Christopher Kings-Lynne wrote:
> Shouldn't this patch need some pg_dump changes?  And doc changes?  Maybe
> even psql changes?
>
> How is NO MAXVALUE and NO MINVALUE stored in the database?  How are they
> recreated that way after a dump?

They're not stored.  According to the spec they're simply aliases to the
default values, as such we store the default values.

I suppose if you wanted to make the dump portable to other databases one
could store bools for these.

> > -----Original Message-----
> > From: pgsql-committers-owner@postgresql.org
> > [mailto:pgsql-committers-owner@postgresql.org]On Behalf Of Bruce Momjian
> > - CVS
> > Sent: Thursday, 13 February 2003 1:25 PM
> > To: pgsql-committers@postgresql.org
> > Subject: [COMMITTERS] pgsql-server/src/backend commands/sequence.c p ...
> >
> >
> > CVSROOT:    /cvsroot
> > Module name:    pgsql-server
> > Changes by:    momjian@postgresql.org    03/02/13 00:25:25
> >
> > Modified files:
> >     src/backend/commands: sequence.c
> >     src/backend/parser: gram.y
> >
> > Log message:
> >     Adds in NO MAXVALUE and NO MINVALUE options for create
> > sequence per 200X
> >     spec, which will also make alter sequence a touch easier.
> >
> >     sequence.c  init_params() will check for settings which have been
> >     defined twice, and complain.
> >
> >     Rod Taylor
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc