Re: REFERENCES error message complaint, suggestion - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: REFERENCES error message complaint, suggestion
Date
Msg-id 20040304082644.C18208@mofo.meme.com
Whole thread Raw
In response to Re: REFERENCES error message complaint, suggestion  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: REFERENCES error message complaint, suggestion
List pgsql-general
On 2004.03.03 21:37 Tom Lane wrote:
> "Karl O. Pinc" <kop@meme.com> writes:
> > It'd be nice if the error message from a REFERENCES
> > constraint mentioned the column name into which
> > the bad data was attempted to be inserted.
>
> You mean like this?

> DETAIL:  Key (fk)=(1) is not present in table "foo".

Exactly!  :)

Does 7.4 do something similar with CHECK constraints?

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: META: Filtering viruses/worms
Next
From: Eva Hovelsrød
Date:
Subject: Inherited tables and foreign keys