Re: pg_extension_config_dump() function and sequences

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: pg_extension_config_dump() function and sequences
Date: 2016-01-18 06:10:42
Message-ID: CAB7nPqS_v=s7L0jsx2bL1NYz8YocKQFcw4G2zZ_6e8H4NNpNUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)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 Content-Type Size
extension-mark-seq-v1.patch binary/octet-stream 2.3 KB

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Seb Mel 2016-01-18 12:15:28 Streaming Replication and Hash Indices
Previous Message Alexander Law 2016-01-17 15:34:15 Re: Graphic to visualize data flow between processes, buffers and files