"Michael ." <[EMAIL PROTECTED]> writes:
> [ SQL function that references a TEMP table ]
> How do I get these functions to import correctly if it
> fails due to this "current_transaction" table not
> being found?
I don't think there is any good solution in 7.3, because it will insist
on trying to validate the function body. A hack workaround is to create
the "current_transaction" table (as a plain, not TEMP, table), then
import your dump, then drop the table.
7.4 has a better solution (you can turn off function body checking in
CREATE FUNCTION), and 7.4's pg_dump will use it.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
