Re: [HACKERS] pg_dump and INCREMENT BY

2004-04-07 Thread scott.marlowe
On Wed, 7 Apr 2004, Dennis Bjorklund wrote: > On Wed, 7 Apr 2004, Dennis Bjorklund wrote: > > Replying to myself here :-) > > > wants to import it into a 7.3 database. Use the 7.3 dump you might say, > > but since BY does not do anything why not remove it from the dump output? > > I just reali

Re: [HACKERS] pg_dump and INCREMENT BY

2004-04-07 Thread Tom Lane
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > I just realized there is yet another new construct in 7.4. The sequences > are created with NO MAXVALUE (and MINVALUE). Couldn't these just be > removed in the pg_dump output in this case. It's the default anyway, > right. IIRC, these changes were to

Re: [HACKERS] pg_dump and INCREMENT BY

2004-04-07 Thread Dennis Bjorklund
On Wed, 7 Apr 2004, Dennis Bjorklund wrote: Replying to myself here :-) > wants to import it into a 7.3 database. Use the 7.3 dump you might say, > but since BY does not do anything why not remove it from the dump output? I just realized there is yet another new construct in 7.4. The sequences

[HACKERS] pg_dump and INCREMENT BY

2004-04-07 Thread Dennis Bjorklund
In 7.4 there is an optional BY that are allowed in the definiton of sequences: CREATE [ TEMPORARY | TEMP ] SEQUENCE namn [ INCREMENT [ BY ] ökning ] [ MINVALUE minvärde | NO MINVALUE ] [ MAXVALUE maxvärde | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] (some swe