Re: sequences and pg_upgrade

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sequences and pg_upgrade
Date: 2016-10-03 04:15:41
Message-ID: CAB7nPqQEi0iEP4x-YBs+zaC3KmwusCbeE45DYc-DAMmGxWqN3Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Oct 1, 2016 at 1:50 AM, Anastasia Lubennikova
<a(dot)lubennikova(at)postgrespro(dot)ru> wrote:
> 23.09.2016 21:06, Peter Eisentraut:
>>
>> Here is an updated patch set. Compared to the initial set, I have
>> changed pg_dump's sorting priorities so that sequence data is always
>> after table data. This would otherwise have introduced a problem
>> because sortDataAndIndexObjectsBySize() only considers consecutive
>> DO_TABLE_DATA entries. Also, I have removed the separate
>> --sequence-data switch from pg_dump and made it implicit in
>> --binary-upgrade. (So the previous patches 0002 and 0003 have been
>> combined, because it's no longer a separate feature.)
>>
>
> The patches are good, no complaints.
> But again, I have the same question.
> I was confused, why do we always dump sequence data,
> because I'd overlooked the --sequence-data key. I'd rather leave this
> option,
> because it's quite non intuitive behaviour...
> /* dump sequence data even in schema-only mode */

Moved to next CF. This is fresh.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-10-03 04:20:56 Re: delta relations in AFTER triggers
Previous Message Michael Paquier 2016-10-03 04:14:23 Re: asynchronous and vectorized execution