Pritesh Shah <pritesh.krish@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq