[GENERAL] How to get schema name which violates fk constraint

[Andrus]

FK violation erroro is displayed as

7/23503:ERROR: insert or update on table "summak" violates foreign key 
constraint "summak_kontonr_fkey1"
Key (kontonr)=(2421      ) is not present in table "konto".
I have large numbers of schemas all containing tables with same name.

How to determine schema name where error occurs?

Andrus. 


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general