How to get schema name which violates fk constraint

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get schema name which violates fk constraint
Date: 2008-10-14 15:43:30
Message-ID: gd2ep9$htj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Haszlakiewicz 2008-10-14 15:49:47 Re: Re: BUG #4078: ERROR: operator does not exist: numeric = character varying
Previous Message Francisco Figueiredo Jr. 2008-10-14 15:30:39 Re: Why select 1 where current_date = 'infinity'; doesn't work?