Re: Getting more detail in plpython error messages

2022-03-07 Thread Jeff Ross
On 3/7/22 11:06 AM, Tom Lane wrote: Jeff Ross 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

Re: Getting more detail in plpython error messages

2022-03-07 Thread Tom Lane
Jeff Ross writes: > With plpython (both u and 3u) all I see printed is the ERROR part. >     try: >     check = plpy.execute("delete from inspection where bundle_id in > (select id from test_archive_20170401.load order by id)") >     except plpy.SPIError as e: >     plpy.notice("Erro