Re: function "XXX" already exists with same argument types

Alexander Farber wrote:
>>> psql:pref-2011-10-05-a.sql:339: ERROR:  function "pref_update_match"
>>> already exists with same argument types
>>> ALTER FUNCTION

>> Likely someone mistakenly added the functions to template1 of the machine you're restoring onto and
>> they're getting added to the new database when it's created.

> # psql -U postgres -W template1
> Password for user postgres:
> psql (8.4.7)
> Type "help" for help.
>
> template1=# \df
> List of functions
> Schema | Name | Result data type | Argument data types | Type
> --------+------+------------------+---------------------+------
> (0 rows)

That should be \dfS

That the functions are in template1 is just a theory - the fact
is that they were already defined in the database where you
restored the dump.

What is you drop and recreate the database, then run
\dfS in a superuser psql session to make sure there is nothing there,
then restore.

Yours,
Laurenz Albe