Getting more detail in plpython error messages
| От | Jeff Ross |
|---|---|
| Тема | Getting more detail in plpython error messages |
| Дата | |
| Msg-id | 55b1d962-ee85-6fa7-d594-cdd905eb6640@openvistas.net обсуждение исходный текст |
| Ответы |
Re: Getting more detail in plpython error messages
|
| Список | pgsql-general |
Hi all,
In psql a database error will print both ERROR: and DETAIL: lines.
postgres@testdb# delete from inspection where bundle_id in (select id
from test_archive_20170401.load order by id);
ERROR: update or delete on table "inspection" violates foreign key
constraint "inspection_weather_inspection_id_inspection_id_fk" on table
"inspection_weather"
DETAIL: Key (id)=(158967) is still referenced from table
"inspection_weather".
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("Error!", e)
postgres@testdb# select * from test_delete();
NOTICE: ('Error!', ForeignKeyViolation('update or delete on table
"inspection" violates foreign key constraint
"inspection_weather_inspection_id_inspection_id_fk" on table
"inspection_weather"',))
Is there a way to get the DETAIL part as well?
Thanks,
Jeff
В списке pgsql-general по дате отправления: