Re: pg_restore error: function plpgsql_call_handleralready exists with same argument types - Mailing list pgsql-admin

"Nick Fankhauser" <nickf@ontko.com> writes:
> We've never touched template1, but just to make sure, I tried using
> template0 to ensure an empty DB with the same results:

> nickf@morgai:~$ createdb -D PG_ALPHA -T template0 test
> CREATE DATABASE
> nickf@morgai:~$ pg_restore -dalpha  test.dump.tar
> pg_restore: [archiver (db)] could not execute query: ERROR:  function
> plpgsql_call_handler already exists with same argument types
> nickf@morgai:~$

Er, it looks like you created an empty 'test' and then tried (again)
to restore into the not-so-empty 'alpha'.

            regards, tom lane