Re: [HACKERS] Access Error Details from PL/pgSQL

2012-02-21 Thread aasat
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_hintTEXT;
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


Re: [HACKERS] Access Error Details from PL/pgSQL

2012-02-21 Thread Pavel Stehule
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


[HACKERS] Access Error Details from PL/pgSQL

2012-02-13 Thread David E. Wheeler
Hackers,

In PL/pgSQL exception handling, I'm able to access the error code (SQLSTATE) 
and error message (SQLERRM). Is there any way to get at error details (yet)? If 
not, could SQLDETAIL or some such be added?

Thanks,

David
-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] Access Error Details from PL/pgSQL

2012-02-13 Thread Pavel Stehule
Hello

2012/2/13 David E. Wheeler da...@justatheory.com:
 Hackers,

 In PL/pgSQL exception handling, I'm able to access the error code (SQLSTATE) 
 and error message (SQLERRM). Is there any way to get at error details (yet)? 
 If not, could SQLDETAIL or some such be added?


no in stable

http://www.depesz.com/2011/07/20/waiting-for-9-2-stacked-diagnostics-in-plpgsql/

Pavel

 Thanks,

 David
 --
 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


Re: [HACKERS] Access Error Details from PL/pgSQL

2012-02-13 Thread David E. Wheeler
On Feb 13, 2012, at 9:30 AM, Pavel Stehule wrote:

 no in stable
 
 http://www.depesz.com/2011/07/20/waiting-for-9-2-stacked-diagnostics-in-plpgsql/

Ah, great, I had forgotten about that.

Thank you,

David


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers