Re: PL/pgSQL syntax help? - Mailing list pgsql-general

From Tom Lane
Subject Re: PL/pgSQL syntax help?
Date
Msg-id 17910.971151338@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL syntax help?  (Jinsoo Hwang <jshwang@anova.inha.ac.kr>)
List pgsql-general
Jinsoo Hwang <jshwang@anova.inha.ac.kr> writes:
> ERROR  plpgsql: cache lookup for proc 163937 failed.

I suspect that you deleted and recreated the function after
creating the trigger.  Currently you must recreate the trigger
after you recreate the function --- but the system won't tell
you so in any direct fashion.  Annoying, isn't it?

            regards, tom lane

pgsql-general by date:

Previous
From: Gunnar R|nning
Date:
Subject: Re: Re: JDBC Performance
Next
From: Tom Lane
Date:
Subject: Re: Regression tests of plain 7.0.2 fails