Postgres Pro
Downloads
Home   >   mailing lists

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

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

Maybe to report schema name only if it is not public or if same table
exists in different schemas or report it in detail message or hint.

Andrus.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get schema name which violates fk constraint
Next
From: "Scott Marlowe"
Date:
Subject: Re: How to get schema name which violates fk constraint