Re: Access Error Details from PL/pgSQL

I have question. GET STACKED DIAGNOSTICS work only in exception block? is it
posible to use it in separate function called in exception block?


EXCEPTION  WHEN others THEN   peform log_error();
END;

CREATE OR REPLACE FUNCTION log_error() RETURNS boolean AS
$BODY$
declare   v_state   TEXT;   v_msg     TEXT;   v_detail  TEXT;   v_hint    TEXT;   v_context TEXT;
begin
 GET STACKED DIAGNOSTICS           v_state   = RETURNED_SQLSTATE,           v_msg     = MESSAGE_TEXT,
v_detail = PG_EXCEPTION_DETAIL,           v_hint    = PG_EXCEPTION_HINT,           v_context = PG_EXCEPTION_CONTEXT;
  raise notice E'Got exception:           state  : %           message: %           detail : %           hint   : %
     context: %', v_state, v_msg, v_detail, v_hint, v_context;
 
end;
$BODY$
LANGUAGE plpgsql VOLATILE;



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Access-Error-Details-from-PL-pgSQL-tp5479926p5501584.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.