Re: Predictable order of SQL commands in pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dmitry(at)koterov(dot)ru
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Predictable order of SQL commands in pg_dump
Date: 2008-09-21 01:28:09
Message-ID: 6000.1221960489@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Dmitry Koterov" <dmitry(at)koterov(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2008-09-21 01:55:20 Re: [patch] fix dblink security hole
Previous Message Dmitry Koterov 2008-09-21 01:05:02 Predictable order of SQL commands in pg_dump