> pg_dump has a hard time with circular dependencies :-(
but on the plus side, pg_dump is really fast! much faster than dump
utilities of other databases I've seen.
> Have you considered using a sequence, rather than generating
> new values
> as shown above? The approach you are using is extremely fragile:
> consider what happens if two backends try to insert at the same time.
a sequence it is! thanks.
eric