I am working on an implementation of 'ALTER FUNCTION' and have run into a
problem.
plpgsql. plperl and pltcl all cache the result of a compile of prosrc.
Which leads to things like:
mhh=# create function f() returns integer as 'begin return 42; end;' language
'plpgsql';
CREATE
mhh=# select f();f
----42
(1 row)
mhh=# alter function f() as 'begin return 44; end;';
ALTER
mhh=# select f();f
----42
(1 row)
mhh=# select proname, prosrc from pg_proc where proname = 'f';proname | prosrc
---------+-----------------------f | begin return 44; end;
Of course, leaving psql and re-entering fixes the problem. But the same
problem is manifested between concurrent sessions as well.
I would like to propose that a new attribute be added to pg_proc 'proserial'.
'CREATE FUNCTION' will set proserial to 0. 'ALTER FUNCTION' will increment it
each time. It would be up to the individual PL handlers to check to make sure
that their cache is not out of date.
Is there a better way to solve this problem?
--
Mark Hollomon