Re: function "XXX" already exists with same argument types - Mailing list pgsql-general

From Alexander Farber
Subject Re: function "XXX" already exists with same argument types
Date
Msg-id CAADeyWg2Y-tp8=AyB_4EsjgZjMOib+QMwK5RZ_y=whABMZ5wag@mail.gmail.com
Whole thread Raw
In response to Re: function "XXX" already exists with same argument types  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Thanks for your comments,
the problem has disappeared on the 2nd restore,
but I'll keep you suggestions in mind!

On Thu, Oct 6, 2011 at 10:00 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
>> 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.

pgsql-general by date:

Previous
From: pasman pasmański
Date:
Subject: Re: Bulk processing & deletion
Next
From: Alexander Farber
Date:
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10