Re: pg_extension_config_dump() function and sequences - Mailing list pgsql-docs

From Michael Paquier
Subject Re: pg_extension_config_dump() function and sequences
Date
Msg-id CAB7nPqS_v=s7L0jsx2bL1NYz8YocKQFcw4G2zZ_6e8H4NNpNUg@mail.gmail.com
Whole thread Raw
In response to pg_extension_config_dump() function and sequences  (Philippe BEAUDOIN <phb.emaj@free.fr>)
Responses Re: pg_extension_config_dump() function and sequences  (Philippe BEAUDOIN <phb.emaj@free.fr>)
List pgsql-docs
On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.emaj@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

Attachment

pgsql-docs by date:

Previous
From: Alexander Law
Date:
Subject: Re: Graphic to visualize data flow between processes, buffers and files
Next
From: Seb Mel
Date:
Subject: Streaming Replication and Hash Indices