On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.e...@free.fr> wrote: > The page "Packaging Related Objects into an Extension" has a third chapter > dealing with "Extension Configuration Tables". A final paragraph would be > useful to explain that: > > The pg_extension_config_dump() function can also register sequences, so that > the current properties of the registered sequences are saved by pg_dump and > later restored. The function can support sequences either explicitely > created with an ALTER SEQUENCE statement or implicitely created when a table > contains SERIAL or BIGSERIAL columns. Note that the sequences associated to > SERIAL or BIGSERIAL columns of a configuration table need to be registered > using the pg_extension_config_dump() function if one wants to restore the > properties they had at pg_dump time.
Instead of a single paragraph, perhaps we could make things more generic like in the attached? -- Michael
extension-mark-seq-v1.patch
Description: binary/octet-stream
-- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs