pg_extension_config_dump() function and sequences

От: Philippe BEAUDOIN
Тема: pg_extension_config_dump() function and sequences
Дата: ,
Msg-id: 568C27BD.8030402@free.fr
(см: обсуждение, исходный текст)
Ответы: Re: pg_extension_config_dump() function and sequences  (Michael Paquier)
Список: pgsql-docs

Скрыть дерево обсуждения

pg_extension_config_dump() function and sequences  (Philippe BEAUDOIN, )
 Re: pg_extension_config_dump() function and sequences  (Michael Paquier, )
  Re: pg_extension_config_dump() function and sequences  (Philippe BEAUDOIN, )
   Re: pg_extension_config_dump() function and sequences  (Peter Eisentraut, )
    Re: pg_extension_config_dump() function and sequences  (Michael Paquier, )

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 по дате сообщения:

От: Philippe BEAUDOIN
Дата:
Сообщение: pg_extension_config_dump() function and sequences
От: Kevin Day
Дата:
Сообщение: Document Upper Limit for NAMEDATELEN in pgsql 9.5+