phb.e...@free.fr writes: > When a table is registered as an extension configuration table and contains > a serial column, the current value of the sequence associated to this serial > column is not dumped by pg_dump.
I think the way to make that happen is to also register the sequence as a configuration table of the extension. It's not clear to me that that should happen by default; it would depend a lot on how the extension designer intends to manage modifications of the table. > echo "--> And sequences cannot be registered as 'content to be dumped'" > $PGBIN/psql -ac "select > pg_catalog.pg_extension_config_dump('tbl1_col1_seq','');" This test proves nothing of the kind. Please read the error message: ERROR: pg_extension_config_dump() can only be called from an SQL script executed by CREATE EXTENSION You have to do it in the extension's script. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs