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