On Thu, 2005-03-24 at 17:27 -0500, Tom Lane wrote:
> Andreas Lange <[EMAIL PROTECTED]> writes:
> > Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables
> > got dumped in the wrong order (before their dependecies) and had to get
> > their contents added manually after the restore.
Andreas Lange <[EMAIL PROTECTED]> writes:
> Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables
> got dumped in the wrong order (before their dependecies) and had to get
> their contents added manually after the restore. I've atleast isolated
> the part where things go wrong.
"Gerard Krupa" <[EMAIL PROTECTED]> writes:
> I've experienced a similar problem with a data-only dump using 8.0.1's
> pg_dump. It seems that the COPYs (or INSERTs) are generated in
> alphabetical order of table name, ignoring foreign key contraints and
> requiring the output to be post-processed.
Andreas Lange wrote :
> Hi!
>
> Our upgrade from 7.4.6 to 8.0.1 only had one small glitch. Two tables got
dumped in the wrong order
> (before their dependecies) and had to get their contents added manually
after the restore. I've atleast
> isolated the part where things go wrong.
I've experienced