Re: pg_extension_config_dump() function and sequences

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_extension_config_dump() function and sequences
Дата
Msg-id CAB7nPqS_v=s7L0jsx2bL1NYz8YocKQFcw4G2zZ_6e8H4NNpNUg@mail.gmail.com
обсуждение исходный текст
Ответ на pg_extension_config_dump() function and sequences  (Philippe BEAUDOIN <phb.emaj@free.fr>)
Ответы Re: pg_extension_config_dump() function and sequences
Список 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

Вложения

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

Предыдущее
От: Alexander Law
Дата:
Сообщение: Re: Graphic to visualize data flow between processes, buffers and files
Следующее
От: Seb Mel
Дата:
Сообщение: Streaming Replication and Hash Indices