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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org