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

From Ben Chobot
Subject Re: How to get schema name which violates fk constraint
Date
Msg-id 7CD8F0E1-7C22-4C6E-A962-7424B20ED61D@silentmedia.com
Whole thread Raw
In response to Re: How to get schema name which violates fk constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to get schema name which violates fk constraint  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On Oct 22, 2008, at 6:50 AM, Tom Lane wrote:

> In the
> second place, the reason most of our messages don't already contain
> schema names is that in the past we've judged it would be mostly
> clutter; and given the infrequency of complaints I see no reason to
> change that opinion.


Well, FWIW, I also would like to be able to see which schema caused
the violation, as I'm in a similar boat of having the same table name
in multiple schemas.

pgsql-general by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: syncing with a MySQL DB
Next
From: Ivan Sergio Borgonovo
Date:
Subject: gin index and same query misteriously slowing down on a nearly-readonly DB