Re: Predictable order of SQL commands in pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Predictable order of SQL commands in pg_dump
Дата
Msg-id 6000.1221960489@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Predictable order of SQL commands in pg_dump  ("Dmitry Koterov" <dmitry@koterov.ru>)
Ответы Re: Predictable order of SQL commands in pg_dump
Список pgsql-hackers
"Dmitry Koterov" <dmitry@koterov.ru> writes:
> Utility pg_dump dumps the identical database schemas not always
> identically: sometimes it changes an order of SQL statements.

Please provide a concrete example.  The dump order for modern servers
(ie, since 7.3) is by object type, and within a type by object name,
except where another order is forced by dependencies.  And there is no
random component to the dependency solver ;-).  So it should be
behaving the way you want.
        regards, tom lane


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

Предыдущее
От: "Dmitry Koterov"
Дата:
Сообщение: Predictable order of SQL commands in pg_dump
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [patch] fix dblink security hole