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
