Re: misleading error message in 8.5, and bad (?) way deferred uniqueness works - Mailing list pgsql-bugs

From Dean Rasheed
Subject Re: misleading error message in 8.5, and bad (?) way deferred uniqueness works
Date
Msg-id 8e2dbb700908111220u73a93f63habb0c3b6017a6a4c@mail.gmail.com
Whole thread Raw
In response to Re: misleading error message in 8.5, and bad (?) way deferred uniqueness works  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
2009/8/11 Tom Lane <tgl@sss.pgh.pa.us>:
> Anyway it's looking like a slightly nontrivial project. =A0Maybe we should
> just rephrase the error message Hubert is complaining about.
>

Yeah, I can't think of any simple way of distinguishing the 2 error
conditions in that code. Perhaps adding a suitable hint would help, as
well as re-wording the error message:

ERROR: deferrable constraint "foo" does not exist
HINT: You must specify the name of a constraint declared with the
DEFERRABLE option.

 - Dean

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: misleading error message in 8.5, and bad (?) way deferred uniqueness works
Next
From: "Ian Turner"
Date:
Subject: BUG #4974: Equivalent of "= ANY" and "BETWEEN" not observed by planner.