"Nick Fankhauser" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org