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
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 |