Re: pg_extension_config_dump() function and sequences

От: Philippe BEAUDOIN
Тема: Re: pg_extension_config_dump() function and sequences
Дата: ,
Msg-id: 569E992B.20606@free.fr
(см: обсуждение, исходный текст)
Ответ на: Re: pg_extension_config_dump() function and sequences  (Michael Paquier)
Ответы: Re: pg_extension_config_dump() function and sequences  (Peter Eisentraut)
Список: 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, )

Le 18/01/2016 07:10, Michael Paquier a écrit :
> On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <> 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?
It looks much better, indeed.

Philippe.




В списке pgsql-docs по дате сообщения:

От: Philippe BEAUDOIN
Дата:
Сообщение: Re: pg_extension_config_dump() function and sequences
От: Johannes Choo
Дата:
Сообщение: s/user/role/ in section 5.6 of v9.5.0 and 9.6devel of docs.