Create or replace function doesn't work so well - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Create or replace function doesn't work so well
Date
Msg-id Pine.LNX.4.30.0110180005090.628-100000@peter.localdomain
Whole thread Raw
Responses Re: Create or replace function doesn't work so well
Re: Create or replace function doesn't work so well
List pgsql-hackers
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   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Package support for Postgres
Next
From: Tom Lane
Date:
Subject: Re: pg_sorttemp files