Hello
2012/2/21 aasat <satriani@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