pg_extension_config_dump() function and sequences

Поиск
Список
Период
Сортировка
Искать
От
Philippe BEAUDOIN
Тема
pg_extension_config_dump() function and sequences
Дата
Msg-id
568C27BD.8030402@free.fr
Список
Дерево обсуждения
pg_extension_config_dump() function and sequences Philippe BEAUDOIN <phb.emaj@free.fr>
Re: pg_extension_config_dump() function and sequences Michael Paquier <michael.paquier@gmail.com>
Re: pg_extension_config_dump() function and sequences Philippe BEAUDOIN <phb.emaj@free.fr>
Re: pg_extension_config_dump() function and sequences Peter Eisentraut <peter_e@gmx.net>
Re: pg_extension_config_dump() function and sequences Michael Paquier <michael.paquier@gmail.com>
Hi all,

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.

Sorry for my English. This has to be probably reworded a bit.

Best regards.
Philippe Beaudoin.

В списке pgsql-docs по дате отправления
От: Robert Haas
Дата:
От: Kevin Day
Дата:
FAQ