Re: Getting more detail in plpython error messages

From: Jeff Ross <jross(at)openvistas(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Getting more detail in plpython error messages
Date: 2022-03-07 18:12:29
Message-ID: ec601aad-7590-71a0-906f-092fcb526aba@openvistas.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/7/22 11:06 AM, Tom Lane wrote:
> Jeff Ross <jross(at)openvistas(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-03-07 19:35:40 Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Previous Message Tom Lane 2022-03-07 18:06:41 Re: Getting more detail in plpython error messages