Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-05-22 Thread Mark Shewmaker
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.

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-03-24 Thread Tom Lane
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.

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-02-10 Thread Tom Lane
"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.

Re: [BUGS] pg_dump table ordering bug [8.0.1]

2005-02-10 Thread Gerard Krupa
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