Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension
Date
Msg-id 5301.1337534868@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6640: pg_dump does not always dump data of tables marked as editable in extension  (lr@pcorp.us)
Responses Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension  ("Paragon Corporation" <lr@pcorp.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6651: macaddr length constraint violates standard
Next
From: "Paragon Corporation"
Date:
Subject: Re: BUG #6640: pg_dump does not always dump data of tables marked as editable in extension