Re: PL/pgSQL syntax help?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jinsoo Hwang <jshwang(at)anova(dot)inha(dot)ac(dot)kr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL syntax help?
Date: 2000-10-10 04:15:38
Message-ID: 17910.971151338@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jinsoo Hwang <jshwang(at)anova(dot)inha(dot)ac(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-10-10 04:19:13 Re: Regression tests of plain 7.0.2 fails
Previous Message Gunnar R|nning 2000-10-10 04:08:39 Re: Re: JDBC Performance