Hello 2012/2/21 aasat <satri...@veranet.pl>: > I have question. GET STACKED DIAGNOSTICS work only in exception block? is it > posible to use it in separate function called in exception block? >
Stacked diagnostick will be in 9.2 and it is allowed only in exception block. Regards Pavel Stehule > > 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. > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
