Inconsistent treatment of serials in pg_dump

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Inconsistent treatment of serials in pg_dump
Дата
Msg-id 4DC83AA9.2070409@agliodbs.com
обсуждение исходный текст
Ответы Re: Inconsistent treatment of serials in pg_dump
Список pgsql-hackers
All,

Just encountered this:

create table josh ( id serial not null, desc text );

pg_dump -Fc -T josh -f no_josh_dump postgres

pg_dump -Fc -t josh -f josh_dump postgres

pg_restore -d new no_josh_dump
pg_restore -d new josh_dump

pg_restore: [archiver (db)] Error from TOC entry 2645; 1259 49910
SEQUENCE josh_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  relation
"josh_id_seq" already exists

It seems that if I exclude a table using -T, its dependant sequences do
not get excluded.  But if I include it using -t, its dependent sequences
*do* get included.

Is there a reason this is a good idea, or is it just an oversight?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: switch UNLOGGED to LOGGED
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Formatting Curmudgeons WAS: MMAP Buffers