pg_dump and INCREMENT BY - Mailing list pgsql-hackers

From Dennis Bjorklund
Subject pg_dump and INCREMENT BY
Date
Msg-id Pine.LNX.4.44.0404070958040.4551-100000@zigo.dhs.org
Whole thread Raw
Responses Re: pg_dump and INCREMENT BY  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-hackers
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 swedish strings there, but still readable for you)

pg_dump uses this optional keyword BY which seems like a bad idea if one 
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?

-- 
/Dennis Björklund



pgsql-hackers by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: Regression from 7.3 to 7.4
Next
From: Dennis Bjorklund
Date:
Subject: Re: pg_dump and INCREMENT BY