Re: FK Constraint sort order with pg_dump

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: FK Constraint sort order with pg_dump
Дата
Msg-id CAKFQuwbGEwwxRK4eCvv=2e=G0_wO77s3AnHny4yt1JfqsHg_2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: FK Constraint sort order with pg_dump  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Thu, Jul 21, 2022 at 10:49 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 7/21/22 10:25, Christian Barthel wrote:
> Hello,
>
> The sorting order of FK constraints with the same name is based on the
> OID (because it lands in the “Usually shouldn’t get here” OID comparison
> block at [1]).  Wouldn’t it be better if the order of those constraints
> were based on the table name?
>

Why does it matter?


As the code comment says:

/* To have a stable sort order, break ties for some object types */

This seems like it is simply a missed case.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: FK Constraint sort order with pg_dump
Следующее
От: Christian Barthel
Дата:
Сообщение: Re: FK Constraint sort order with pg_dump