How to get schema name which violates fk constraint

["Andrus" <kobruleht2@xxxxxx>]

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general