Обсуждение: how to retrieve error message details

Поиск
Список
Период
Сортировка

how to retrieve error message details

От
"Andrus"
Дата:
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.