Re: [GENERAL] PL/PGSQL

From: Jens Felber <jfe(at)gek-online(dot)de>
To: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] PL/PGSQL
Date: 1999-08-23 12:29:36
Message-ID: 3.0.6.32.19990823142936.00918940@62.156.187.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 14:46 23.08.99 +0300, Herouth Maoz wrote:
>At 14:13 +0300 on 23/08/1999, Jens Felber wrote:
>
>
>Sounds to me that you have created the trigger with some version of the
>function, and then you redefined the function, dropped the old one, or some
>such. Once this is done, the trigger will give you that error message,
>since it works by oid and not the function name.
>
>Try to drop the trigger, if you haven't already.

Hi folks,
the problem is solved - thanks for all hints.
Like Herouth said - I've droped the function and create an new version.
But the trigger was the old version.
After a drop of both and newcreation - it works fine.

Thanks a lot.
Jens

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steffen E. Thorkildsen 1999-08-23 14:28:52 PostgreSQL locking problem!
Previous Message Herouth Maoz 1999-08-23 11:46:44 Re: [GENERAL] PL/PGSQL