"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