Re: normal user dump gives error because of plpgsql

John Sidney-Woollett <johnsw@wardbrook.com> 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