Env: Windows XP
sp2
Version:
8.2.1
I'm attempting to
write a function which produces a script. The script will contain steps
necessary to drop/recreate all the functions. I've got a helper function
called 'dropprocsbyname' which takes a schema and a proc name, finds all
matching pg_proc rows and executes 'drop function xyz' on
them.
So the output of my
'recreate all procs' function looks like this:
select * from
common.dropprocsbyname('common','proc1');
create or replace
function common.proc1() returns bool as
$$body$$
etc
$$body$$
language 'plpgsql'
volatile;
etc.. for each proc
in the common schema.
I get many, but not
all, errors like this:
"psql:e:/pgla_export.txt:1208: ERROR: cache lookup failed for
function 22542
CONTEXT: PL/pgSQL function "dropprocsbyname" line 23 at execute statement"
CONTEXT: PL/pgSQL function "dropprocsbyname" line 23 at execute statement"
with the same
function oid each time.
When I rerun the
script, the oid in the error changes. So, I'm guessing that it has to do
with dropping/recreating my "dropprocsbyname" function, but I cannot figure out
when its being cached and how to overcome the error.
Chris
Fischer
Database
Engineer
