"Nick Fankhauser" <nickf(at)ontko(dot)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(at)morgai:~$ createdb -D PG_ALPHA -T template0 test
> CREATE DATABASE
> nickf(at)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(at)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