Postgres Pro
Downloads
Home   >   mailing lists

How to get schema name which violates fk constraint - Mailing list pgsql-general

From Andrus
Subject How to get schema name which violates fk constraint
Date
Msg-id gd2ep9$htj$1@news.hub.org
Whole thread Raw
Responses Re: How to get schema name which violates fk constraint  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Optimizing queries with projected columns
Next
From: carlos.ohiggins@yahoo.com
Date:
Subject: create parent after children