Re: [HACKERS] pgadmin debug on windows

[Roberto Icardi]

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 


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster