pg_dump vs data-only dumps vs --disable-triggers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pg_dump vs data-only dumps vs --disable-triggers
Дата
Msg-id 12664.1216941114@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: pg_dump vs data-only dumps vs --disable-triggers  (Andrew Dunstan <andrew@dunslane.net>)
Re: pg_dump vs data-only dumps vs --disable-triggers  (Stephen Frost <sfrost@snowman.net>)
Re: pg_dump vs data-only dumps vs --disable-triggers  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
There's some fairly squirrely logic in pg_dump/pg_restore that tries to
detect whether it's doing a data-only operation, ie, no schema
information is to be dumped or restored.  The reason it wants to
know this is to decide whether to enable the --disable-triggers
code.  However, since --disable-triggers is off by default and has
to be manually requested, I'm not sure why we've got all this extra
complexity in there.  (Actually, I'm sure the reason is that that
code predates the existence of the --disable-triggers switch, but
anyway...)

Simon's patch to split up --schema-only into two switches has broken
this logic, but I'm inclined to just rip it out rather than trying
to fix it.  If the user says --disable-triggers, he should get
trigger disable commands around the data part of the dump, no matter
what he said or didn't say about schema dumping.

Objections?
        regards, tom lane


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

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: Do we really want to migrate plproxy and citext into PG core distribution?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Do we really want to migrate plproxy and citext into PG core distribution?