"Geoff Ellis" <[EMAIL PROTECTED]> writes:
> === ERROR: fmgr_info: function 696542: cache lookup failed =
This is on 7.3? My first guess would have been that you deleted and
recreated the function without recreating the trigger that references
it. But 7.3 should not let you do that.
> I've t
I've got a tiny problem with how I want this function to work.
On and insert/delete from a table, I want to check to see if a field
contains a certain valule. If it does, not to insert or delete the record.
If it doesn't I want to go ahead and insert/delete the record.
Here's my function.
-- Fun
t: 11 December 2002 15:57
To: [EMAIL PROTECTED]
Cc: Pgsql-Admin (E-mail)
Subject: Re: [ADMIN] Function Problem
On Wed, 2002-12-11 at 07:38, Geoff wrote:
>
> RETURN NULL;
>
> END
>
> ' LANGUAGE 'plpgsql' ;
>
Look over Jakub's email, it's on the right trac
On Wed, 2002-12-11 at 07:38, Geoff wrote:
>
> RETURN NULL;
>
> END
>
> ' LANGUAGE 'plpgsql' ;
>
Look over Jakub's email, it's on the right track. FWIW, you also need a
; after your END statement, which I believe is the actual error your
seeing.
Robert Treat
---(end o
hi,
> I've got this function which works off a trigger.
> The trigger is calling the function ok, but I get this error.
>
> NOTICE: plpgsql: ERROR during compile of mon_sum_update near line 43
> ERROR: parse error at or near ""
>
> Now line 43 is this either the return null or end statement at th
I've got this function which works off a trigger.
The trigger is calling the function ok, but I get this error.
NOTICE: plpgsql: ERROR during compile of mon_sum_update near line 43
ERROR: parse error at or near ""
Now line 43 is this either the return null or end statement at the end of
the funct