Re: misleading error message in 8.5, and bad (?) way deferred uniqueness works

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