Re: Access Error Details from PL/pgSQL

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Access Error Details from PL/pgSQL
Date: 2012-02-13 17:30:31
Message-ID: CAFj8pRAr_mMB1P5i+7BocQ3M+kfMbD+=BttYqbEXV9gX0an=Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

2012/2/13 David E. Wheeler <david(at)justatheory(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2012-02-13 17:32:58 Re: CUDA Sorting
Previous Message David E. Wheeler 2012-02-13 17:27:16 Access Error Details from PL/pgSQL