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