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