peter=# drop function test();
DROP
peter=# create or replace function test() returns int as 'return 1;' language plperl;
CREATE
peter=# select test();
test
------
1
(1 row)
peter=# create or replace function test() returns int as 'return 2;' language plperl;
CREATE
peter=# select test();
test
------
1
(1 row)
The same can be observed with PL/Tcl and PL/Python, but not with PL/pgSQL
and plain SQL. Obviously, there is some caching going on, and a session
restart fixes everything, but the failure with this plain and simple test
case makes me wonder about this new feature...
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
