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

[BUGS] pg_dump table ordering bug [8.0.1]

2005-02-07 Thread Andreas Lange
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. Two files are attached, related as follows (al