pg_dump dumps event triggers and transforms unconditionally

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pg_dump dumps event triggers and transforms unconditionally
Дата
Msg-id 8795.1452631064@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: pg_dump dumps event triggers and transforms unconditionally  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
I noticed $subject while trying to fix the extension membership problem
Karsten Hilbert complained of last week.  I do not think that if I ask
for a dump of a single table, that should include event triggers.

AFAICT event triggers don't belong to any particular schema, so I'd
propose that they be dumped only when include_everything is true,
which is the usual rule for objects that don't belong to any schema.

Transforms have got the same issue, which means that the dump of a
database containing, eg, hstore_plperl is outright broken: it will
dump both the extension *and* a CREATE TRANSFORM command.  Again, they
ought to obey the default rules for schema-less objects, which in
this case is "dump if include_everything and not an extension member".
        regards, tom lane



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Speedup twophase transactions
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump dumps event triggers and transforms unconditionally