Re: Syntax check for functions? - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Syntax check for functions?
Date
Msg-id 20020712073731.GA31002@nic.fr
Whole thread Raw
In response to Syntax check for functions?  (Andreas Schlegel <schlegel@software.b.uunet.de>)
List pgsql-general
On Thu, Jul 11, 2002 at 07:23:23PM +0200,
 Andreas Schlegel <schlegel@software.b.uunet.de> wrote
 a message of 37 lines which said:

> I just wrote my first function and trigger in Postgres an dit won't work :-(
>
> I get the error: "fmgr_info: function 541860: cache lookup failed"

It is not a syntax error. It is simply because the binding between the
trigger and the function is done once and stays in the cache after
(you probably changed the function after the trigger). You have to
drop the trigger and recreate it.


pgsql-general by date:

Previous
From: frbn
Date:
Subject: Re: deletion of records
Next
From: Martijn van Oosterhout
Date:
Subject: Re: again trouble