pg_restore error: function plpgsql_call_handler already exists with same argument types

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: pg_restore error: function plpgsql_call_handler already exists with same argument types
Date: 2002-11-27 13:16:22
Message-ID: NEBBLAAHGLEEPCGOBHDGMEPEGDAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi-

I'm trying to do a dump & restore of a complete database using tar archive
format. I've previously used the text dump approach, so I'm very new to this
method.

I created the dump using:

pg_dump -Ft alpha > alpha.dump.tar

I'm trying to restore into an empty db using:

pg_restore -d alpha2 alpha.dump.tar

and I get this error:

pg_restore: [archiver (db)] could not execute query: ERROR: function
plpgsql_call_handler already exists with same argument types

I found a brief mention of this error in an old novice list posting, but it
seemed to be connected to a plain text dump file, so I'm still mystified.

Any thoughts?

Thanks.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2002-11-27 14:00:50 Re: pg_restore error: function plpgsql_call_handler
Previous Message Marco Kärger 2002-11-27 08:45:06 change datatypes