Search Postgresql Archives

how to retrieve error message details

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux