Pritesh Shah <pritesh(dot)krish(at)gmail(dot)com> writes:
> I know that the CREATE FUNCTION part should come before using it in
> CREATE OPERATOR. If it was one or two databases i would have edited
> the plain text dump file by hand appropriately.
If you can use the pg_dump from the 8.0 release, it should get this
right. Prior versions don't do real dependency analysis but rely on
dumping in OID order, which is not a very reliable guide.
regards, tom lane