| From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: function "XXX" already exists with same argument types |
| Date: | 2011-10-14 08:25:01 |
| Message-ID: | CAADeyWg2Y-tp8=AyB_4EsjgZjMOib+QMwK5RZ_y=whABMZ5wag@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)albe(at)wien(dot)gv(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Farber | 2011-10-14 09:14:27 | Re: Slow query: select * order by XXX desc offset 10 limit 10 |
| Previous Message | pasman pasmański | 2011-10-14 06:06:32 | Re: Bulk processing & deletion |