Create or replace function doesn't work so well
| От | Peter Eisentraut |
|---|---|
| Тема | Create or replace function doesn't work so well |
| Дата | |
| Msg-id | Pine.LNX.4.30.0110180005090.628-100000@peter.localdomain обсуждение исходный текст |
| Ответы |
Re: Create or replace function doesn't work so well
Re: Create or replace function doesn't work so well |
| Список | 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 по дате отправления: