how to retrieve error message details

Started by Andrusover 20 years ago1 messagesgeneral
Jump to latest
#1Andrus
eetasoft@online.ee

in PgAdmin, running wrong insert command causes error like

ERROR: insert or update on table "dok" violates foreign key constraint
"dok_klient_fkey"
DETAIL: Key (klient)=(gg ) is not present in table "klient".

Running same command through ODBC driver returns only first line.

How to retrieve DETAIL line (key name and value) which violates referential
integrity from Postgres after receiving this error ?

Andrus.