John Sidney-Woollett <johnsw@xxxxxxxxxxxxx> writes:
> I'm pretty sure I had the same problem when using pg_restore. If
> pl/pgsql is installed in template1, then the restore fails.
> And I couldn't find any solution to this on the list either.
You're supposed to restore into a database cloned from template0,
not template1.
> Can pg_restore be made to ignore the error?
It does, at least since 8.0.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
