pg_dump and INCREMENT BY

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump and INCREMENT BY
Date: 2004-04-07 08:01:36
Message-ID: Pine.LNX.4.44.0404070958040.4551-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dennis Bjorklund 2004-04-07 08:16:36 Re: pg_dump and INCREMENT BY
Previous Message Dennis Bjorklund 2004-04-07 07:57:31 Re: Regression from 7.3 to 7.4