pg_dump and INCREMENT BY

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема pg_dump and INCREMENT BY
Дата
Msg-id Pine.LNX.4.44.0404070958040.4551-100000@zigo.dhs.org
обсуждение исходный текст
Ответы Re: pg_dump and INCREMENT BY  (Dennis Bjorklund <db@zigo.dhs.org>)
Список 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 по дате отправления:

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: Regression from 7.3 to 7.4
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: pg_dump and INCREMENT BY