pgsql-bugs@postgresql.org writes:
> Would it be possible for pg_dump to do the right thing here?
Not real soon :-(. It's possible that 7.4 pg_dump will be smart enough
to handle circular dependencies like this one. The current pg_dump
doesn't even know there is a problem, much less have a strategy for
coping.
I assume you can't simply create the try_it() function before the table
that uses it? (If you rewrote it as a plpgsql function, you probably
could do that, since the body of a PL function isn't checked when it's
defined. Perhaps this can serve as a workaround until pg_dump gets
smarter about dependencies.)
regards, tom lane