how to retrieve error message details

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: how to retrieve error message details
Date: 2005-09-02 07:59:18
Message-ID: df90pi$2cjj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Dick Kniep 2005-09-02 12:35:00 Re: Schema problems RedHat / SuSE 9.3 for version 7.4.8
Previous Message Richard Huxton 2005-09-02 07:33:59 Re: same size VARCHAR or INT IX faster?