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: (view raw, whole thread or download thread mbox)
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?

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:

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

In response to


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-2017 The PostgreSQL Global Development Group