how to retrieve error message details - Mailing list pgsql-general

From Andrus
Subject how to retrieve error message details
Date
Msg-id df90pi$2cjj$1@news.hub.org
Whole thread Raw
List pgsql-general
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.



pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: same size VARCHAR or INT IX faster?
Next
From: Dick Kniep
Date:
Subject: Re: Schema problems RedHat / SuSE 9.3 for version 7.4.8