How to get details about referential integrity violations?

From: Johann Uhrmann <johann(dot)uhrmann(at)xpecto(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: How to get details about referential integrity violations?
Date: 2005-04-06 11:18:19
Message-ID: 4253C57B.2020905@xpecto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

is there a way to get the name of the two tables involved
in a referential integrity violation via jdbc?

Up to version 7.3 it was possible to get the names by
parsing the error message of the SQLException.

However, some information has moved to the DETAIL line.
Can this line be retrieved via jdbc or is there even an
API to get the table names?

Kind regards,

Hans

Browse pgsql-general by date

  From Date Subject
Next Message Costin Manda 2005-04-06 11:33:58 Re: very slow after a while...
Previous Message Eylem Koksal 2005-04-06 10:58:26 Download problem - none of the ftp mirrors work