At 17:21 17/07/2002 -0700, Josh Berkus wrote: > > We can remove (3) by just doing a schema-only dump of the original DB. If > > this works, we know it's data related. Ugh. > >It's not data related ... the missing object is a view.
I actually meant here that it may be that dumping the data may somehow be causing pg_dump to fail to dump the schema correctly, though this is the least likely of the 3 possibilities. >-- >-Josh Berkus > Aglio Database Solutions > San Francisco ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster