Re: 9.0: plpgsql eror when restoring a database as a non superuser

stefan <stefan@therp.nl> writes:
> However, due to the fact that in 9.0, the language is in template1 and
> owned by postgres, a non superuser database owner will not have the
> right to create or replace this language in any newly created database
> owned by himself.

True.

> Therefore the only solution I see is to drop plpgsql from template1, or
> writing a wrapper script that exploits the -l and -L options of pg_restore.

Or just ignore the error during restore.

            regards, tom lane