From: Philippe BEAUDOIN <phb.emaj@free.fr>
To: pgsql-docs@postgresql.org
Subject: pg_extension_config_dump() function and sequences
Message-ID: <568C27BD.8030402@free.fr>
Date: Tue, 5 Jan 2016 21:29:49 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.4.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

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.


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs