Horton

Re: Getting more detail in plpython error messages

Jeff Ross <jross@openvistas.net>

View thread View on postgr.es
From: Jeff Ross <jross@openvistas.net>
To: pgsql-general@lists.postgresql.org
Date: 2022-03-07T18:12:29Z
Lists: pgsql-general 
On 3/7/22 11:06 AM, Tom Lane wrote:
> Jeff Ross <jross@openvistas.net> writes:
>> Is there a way to get the DETAIL part as well?
> It's not very well documented AFAICS, but a SPIError object has a
> "detail" attribute, so "e.detail" should help you.  It looks like
> you might prefer to print "e.spidata", which seems to contain all
> the available fields.
>
> 			regards, tom lane
>
>
Thank you, Tom!  As always, that is exactly what I need.

Jeff