Saturday, September 20, 2008

Re: [HACKERS] Predictable order of SQL commands in pg_dump

"Dmitry Koterov" <> 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

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: