Re: pgadmin debug on windows - Mailing list pgsql-hackers

From Roberto Icardi
Subject Re: pgadmin debug on windows
Date
Msg-id BAY143-DAV152F5AE9767AA8220F1494F79A0@phx.gbl
Whole thread Raw
In response to Re: pgadmin debug on windows  ("Roberto Icardi" <roberto_icardi@hotmail.com>)
Responses Re: pgadmin debug on windows
List 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 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Latin vs non-Latin words in text search parsing
Next
From: "Trevor Talbot"
Date:
Subject: Re: [GENERAL] 8.2.3: Server crashes on Windows using Eclipse/Junit