From: | "Roberto Icardi" <roberto_icardi(at)hotmail(dot)com> |
---|---|
To: | "Dave Page" <dpage(at)postgresql(dot)org> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pgadmin debug on windows |
Date: | 2007-10-22 14:42:45 |
Message-ID: | BAY143-DAV152F5AE9767AA8220F1494F79A0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Please post the definition of an affected function, along with the
> output from the following queries:
>
> select * from pldbg_get_proxy_info();
> select * from pldbg_get_target_info('16480', 'o');
>
> (where 16480 is replaced with the oid of the affected function).
>
> Thanks, Dave
>
CREATE OR REPLACE FUNCTION public.prova(provain character varying)
RETURNS character varying AS
$BODY$
begin
if (provain = 'A') then
return 'INVALIDO';
else
return 'VALIDO';
end if;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER FUNCTION prova(character varying) OWNER TO postgres;
select * from pldbg_get_proxy_info();
"PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)";80300;3;3924
select * from pldbg_get_target_info('18891', 'o');
18891;2200;1;"1043";"prova";"";"{provain}";16386;"public.prova";f;1043
Thank you for your interest
From | Date | Subject | |
---|---|---|---|
Next Message | Trevor Talbot | 2007-10-22 14:43:35 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
Previous Message | Dave Page | 2007-10-22 14:38:07 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |