Re: Domain Constraint Violation Error Messages

Hi,

On 2018-07-25 17:51:21 +0200, Benjamin Coutu wrote:
> > postgres[15271][1]=# \set VERBOSITY verbose
> > postgres[15271][1]=# INSERT INTO myusers (name, email, token) VALUES('', 'b', 'x');
> > ERROR: 23514: value for domain t_txt violates check constraint "dc_txt"
> > SCHEMA NAME: public
> > DATATYPE NAME: t_txt
> > CONSTRAINT NAME: dc_txt
> > LOCATION: ExecEvalConstraintCheck, execExprInterp.c:3521
> > Time: 0.503 ms
> >
> > That seems to address most of your complaint? Unfortunately the column
> > name is not available, as check constraints can involve more than one
> > column.
> >
>
> Well, the problem is that the underlying column is not referenced, and neither is the table. That's the issue right there.

True. I didn't yet have my first coffee, sorry for that :). I think
it'd possibly not be too hard to add support for naming the TABLE. Would
that already be helpful enough for you?

Greetings,

Andres Freund