Thread: pg_extension_config_dump() function and sequences
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.
On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.emaj@free.fr> 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? -- Michael
Attachment
Le 18/01/2016 07:10, Michael Paquier a écrit : > On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.emaj@free.fr> 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.
On 01/19/2016 03:14 PM, Philippe BEAUDOIN wrote: > Le 18/01/2016 07:10, Michael Paquier a écrit : >> On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.emaj@free.fr> >> wrote: >>> 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. committed
On Mon, Apr 18, 2016 at 12:17 PM, Peter Eisentraut <peter_e@gmx.net> wrote: > On 01/19/2016 03:14 PM, Philippe BEAUDOIN wrote: >> Le 18/01/2016 07:10, Michael Paquier a écrit : >>> On Wed, Jan 6, 2016 at 5:29 AM, Philippe BEAUDOIN <phb.emaj@free.fr> >>> wrote: > >>>> 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. > > committed Thanks. I completely forgot this patch.. -- Michael