Re: pg_extension_config_dump() doesn't register owned sequences

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_extension_config_dump() doesn't register owned sequences
Date: 2015-08-28 02:12:32
Message-ID: CAB7nPqTHE-1iNpCgL+5qsoA-dG2Picf8CK4q9fFA+m3q=g58YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 28, 2015 at 10:16 AM, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> wrote:
> Is it intentional that pg_extension_config_dump() doesn't also add sequences
> owned by a table? If not, I'll work on a patch.

I recall this behavior to be intentional. They are taken into account
only if they are explicitly marked with pg_extension_config_dump()
even in the case of SERIAL sequence, and when dumping the data those
sequences are updated with setval.
Regards,
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Øyvind A. Holm 2015-08-28 03:14:49 patch: version_stamp.pl: Add Git commit info to version if 'git' is specified
Previous Message Jim Nasby 2015-08-28 01:42:36 Re: Support for N synchronous standby servers - take 2