Chris, > Nothing gets silently dropped. It will cause an ERROR on creation and > then keep going, but it won't silently drop it... (unless it's a > binary dump thing...)
Silently dropped on dump, not on restore. > Anyway, pg_dump in CVS does correct dump ordering based on a topological > sort of the pg_depend relation (thank Tom for that). It will of course > only work on a 7.3 or higher backend. Right. The issue is really complex databases which were developed in 7.2 or 7.1, which is missing the pg_depends information. In that case, pg_dump seems to get confused about dependency sorting, and a few objects with long dependency chains simply don't get backed up. I'll see if I can put together a nice demo for this. My concern in reporting this is that there are still a lot of commercial users out there running 7.2, and I'd like to minimize upgrade pain. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
