Hi Thanks for pointing to another thing to fix :)
postgres=# create type public.ret_status as ( status integer, status_text text); CREATE TYPE postgres=# create or replace function pavel ( i_param text ) returns public.ret_status as $$ select 200::int, 'ok'::text; $$ language sql; CREATE FUNCTION postgres=# create or replace function pavel ( i_param text, status OUT int, status_text OUT text ) returns record as $$ select 200::int, 'ok'::text; $$ language sql; ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. Asko On Tue, Aug 5, 2008 at 4:00 PM, Pavel Stehule <[EMAIL PROTECTED]>wrote: > 2008/8/5 Martin Pihlak <[EMAIL PROTECTED]>: > > Pavel Stehule wrote: > >> Hello > >> > >> try version 8.3. There lot of dependencies are solved. > >> > > > > Yes, 8.3 was the version I was testing with. Same results on the HEAD: > > > > $ psql -e -f test.sql > > select version(); > > version > > > > > -------------------------------------------------------------------------------------------------------------------------- > > PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) > 4.1.3 20070929 (prerelease) > > (Ubuntu 4.1.2-16ubuntu2) > > (1 row) > > > > create function foo() returns integer as $$ begin return 1; end; $$ > language plpgsql; > > CREATE FUNCTION > > prepare c1 as select * from foo(); > > PREPARE > > execute c1; > > foo > > ----- > > 1 > > (1 row) > > > > drop function foo(); > > DROP FUNCTION > > create function foo() returns integer as $$ begin return 2; end; $$ > language plpgsql; > > CREATE FUNCTION > > execute c1; > > psql:test.sql:11: ERROR: cache lookup failed for function 36555 > > > > regards, > > Martin > > > > use CREATE OR REPLACE FUNCTION syntax without DROP FUNCTION, CREATE > FUNCTION .. > > Regards > Pavel Stehule > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
