SQL statement in an error report for deferred constraint violation. - Mailing list pgsql-general

From Konrad Witaszczyk
Subject SQL statement in an error report for deferred constraint violation.
Date
Msg-id b2c97292-d907-ba72-e25d-299e2b30f868@FreeBSD.org
Whole thread Raw
Responses Re: SQL statement in an error report for deferred constraintviolation.
List pgsql-general
Hi,

While PQresultErrorField() from libpq allows to get context in which an error
occurred for immediate constraints, and thus an SQL statement which caused the
constraint violation, I cannot see any way to find out which SQL statement
caused an error in case of deferred constraints, in particular deferred foreign
key constraints.

Is there any way to check which SQL statement or at least which row violated a
constraint when it's deferred? If not does anyone know why there is such
restriction?


Konrad


Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PgUpgrade bumped my XIDs by ~50M?
Next
From: Jerry Sievers
Date:
Subject: Re: PgUpgrade bumped my XIDs by ~50M?