Re: [GENERAL] function "XXX" already exists with same argument types

2011-10-14 Thread Alexander Farber
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 wrote: >> template1=# \df >>                        List of functions >>  Schema | Name | Result data type | Argument data types | Type >>

Re: [GENERAL] function "XXX" already exists with same argument types

2011-10-06 Thread Albe Laurenz
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

Re: [GENERAL] function "XXX" already exists with same argument types

2011-10-06 Thread Sim Zacks
On 10/05/2011 05:27 PM, Alexander Farber wrote: Thank you Michael, but no - On Wed, Oct 5, 2011 at 5:24 PM, Michael Glaesemann wrote: psql:pref-2011-10-05-a.sql:339: ERROR:  function "pref_update_match" already exists with same argument types ALTE

Re: [GENERAL] function "XXX" already exists with same argument types

2011-10-05 Thread Alexander Farber
Thank you Michael, but no - On Wed, Oct 5, 2011 at 5:24 PM, Michael Glaesemann 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

Re: [GENERAL] function "XXX" already exists with same argument types

2011-10-05 Thread Michael Glaesemann
On Oct 5, 2011, at 11:21, Alexander Farber wrote: > Hello, > > I use PostgreSQL 8.4 under CentOS 5.7: > > # rpm -qa | grep post > compat-postgresql-libs-4-1PGDG.rhel5 > postgresql-8.4.9-1PGDG.rhel5 > postgresql-server-8.4.9-1PGDG.rhel5 > compat-postgresql-libs-4-1PGDG.rhel5 > postgresql-libs-8

[GENERAL] function "XXX" already exists with same argument types

2011-10-05 Thread Alexander Farber
Hello, I use PostgreSQL 8.4 under CentOS 5.7: # rpm -qa | grep post compat-postgresql-libs-4-1PGDG.rhel5 postgresql-8.4.9-1PGDG.rhel5 postgresql-server-8.4.9-1PGDG.rhel5 compat-postgresql-libs-4-1PGDG.rhel5 postgresql-libs-8.4.9-1PGDG.rhel5 postgresql-devel-8.4.9-1PGDG.rhel5 And perform nightly