Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension
Дата
Msg-id 5301.1337534868@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #6640: pg_dump does not always dump data of tables marked as editable in extension  (lr@pcorp.us)
Ответы Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension
Список pgsql-bugs
lr@pcorp.us writes:
> This seems to be only an issue if a user individually chooses to backup a
> table marked as editable in an extension, but works fine if full backup is
> chosen.

AFAICT this is a misunderstanding of the intended behavior of extension
configuration tables.  The data in them will be dumped when, and only when,
the extension itself is included in the dump.  Moreover, if you have a
mixture of extension-provided and user-provided data in the table, as
seems to be the case here, you really need to take measures to keep
those separate so that you can dump only the user-provided entries.
This is not a "fire and forget" type of feature, it requires nontrivial
effort on the part of the extension author to make it useful.  Please
see
http://www.postgresql.org/docs/9.1/static/extend-extensions.html#AEN51978

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6651: macaddr length constraint violates standard
Следующее
От: "Paragon Corporation"
Дата:
Сообщение: Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension