Skip site navigation (1) Skip section navigation (2)

Re: How to get schema name which violates fk constraint

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get schema name which violates fk constraint
Date: 2008-10-22 02:07:41
Message-ID: dcc563d10810211907n3c59a920ia9eb7cd2a6d5ea58@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Actually this sounds like a TODO to me.  I imagine the db knows the
schema and it's just not reporting it in the error message.  Bruce?
Tom?

On Tue, Oct 14, 2008 at 9:43 AM, Andrus <kobruleht2(at)hot(dot)ee> wrote:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>



-- 
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis

In response to

Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-10-22 02:16:58
Subject: Re: How to free disk space
Previous:From: Guy RouillierDate: 2008-10-21 23:32:09
Subject: Re: Annoying Reply-To

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group