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
|
| Список | pgsql-docs |
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 по дате отправления: