Postgres Pro
Downloads
Home   >   mailing lists

Re: "Cache lookup failed for function" when recreating procs - Mailing list pgsql-general

From Tom Lane
Subject Re: "Cache lookup failed for function" when recreating procs
Date
Msg-id 21190.1173292619@sss.pgh.pa.us
Whole thread Raw
In response to "Cache lookup failed for function" when recreating procs  ("Chris Fischer" <Chris.Fischer@channeladvisor.com>)
List pgsql-general
Tree view 
"Chris Fischer" <Chris.Fischer@channeladvisor.com> writes:
> I'm attempting to write a function which produces a script.  The script
> will contain steps necessary to drop/recreate all the functions.

If you're trying to modify functions that are in live use, don't drop
them.  Just apply CREATE OR REPLACE FUNCTION.  This avoids breaking
cached plans that refer to the function(s) by OID.

            regards, tom lane

pgsql-general by date:

Previous
From: "Chris Fischer"
Date:
Subject: "Cache lookup failed for function" when recreating procs
Next
From: "Ed L."
Date:
Subject: Re: invalid page header in pg_statistic