Re: Predictable order of SQL commands in pg_dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Predictable order of SQL commands in pg_dump
Date
Msg-id 6000.1221960489@sss.pgh.pa.us
Whole thread Raw
In response to Predictable order of SQL commands in pg_dump  ("Dmitry Koterov" <dmitry@koterov.ru>)
Responses Re: Predictable order of SQL commands in pg_dump  ("Dmitry Koterov" <dmitry@koterov.ru>)
List 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 by date:

Previous
From: "Dmitry Koterov"
Date:
Subject: Predictable order of SQL commands in pg_dump
Next
From: Joe Conway
Date:
Subject: Re: [patch] fix dblink security hole