From: | Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | pg_extension_config_dump() function and sequences |
Date: | 2016-01-05 20:29:49 |
Message-ID: | 568C27BD.8030402@free.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2016-01-06 17:38:08 | Re: Description tweak for vacuumdb |
Previous Message | Alvaro Herrera | 2016-01-05 19:33:34 | Re: Graphic to visualize data flow between processes, buffers and files |