MIME-Version: 1.0
In-Reply-To: <2911010.1679844383@sss.pgh.pa.us>
References: 
 <CACxJNSkpT8vC0jnsfObZDargLA1vCiP-VKF2ji9y58VaAOSpVA@mail.gmail.com>
 <CAKFQuwYJtF-5Uvqo6ahKkeEAxOKta_yVb3n3at5Y=mvSgC0FrA@mail.gmail.com>
 <2911010.1679844383@sss.pgh.pa.us>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 26 Mar 2023 08:36:58 -0700
Message-ID: 
 <CAKFQuwa00CR2HPxmngsGqx0mGOc4j215gZ4j_v32OYO_gfpQYg@mail.gmail.com>
Subject: Re: How to get column, table or parameter name reporting when
 violating DOMAIN type constraint
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Valerio Battaglia <vabatta@gmail.com>,
	"pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a23fc805f7cf6521"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwa00CR2HPxmngsGqx0mGOc4j215gZ4j_v32OYO_gfpQYg%40mail.gmail.com>
Precedence: bulk

--000000000000a23fc805f7cf6521
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, March 26, 2023, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "David G. Johnston" <david.g.johnston@gmail.com> writes:
> > On Sunday, March 26, 2023, Valerio Battaglia <vabatta@gmail.com> wrote:
> >> Is there a way to obtain more detailed information about the column,
> table
> >> or parameter that is causing the constraint violation in this scenario=
?
> I
> >> would greatly appreciate any guidance or advice you could provide on
> this
> >> matter
>
> > What you see is what you get.
>
> More to the point, you have the wrong mental model: a domain constraint
> violation might not be associated with a table column at all.
>
>
I disagree that the mental model is wrong.  Asking for better context when
constructing rows is a common request not only for domains but even simple
data types like dates or numbers.  Sure, that added context is not always
applicable but when it is the lack of error detail does make life hard.
But it isn=E2=80=99t an easy problem to solve either.

There are existing threads that I may hunt later.  IIRC, you (Tom) even
suggested a possible way forward on this last time it came up.

David J.

--000000000000a23fc805f7cf6521
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sunday, March 26, 2023, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us=
">tgl@sss.pgh.pa.us</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">&quot;=
David G. Johnston&quot; &lt;<a href=3D"mailto:david.g.johnston@gmail.com">d=
avid.g.johnston@gmail.com</a>&gt; writes:<br>
&gt; On Sunday, March 26, 2023, Valerio Battaglia &lt;<a href=3D"mailto:vab=
atta@gmail.com">vabatta@gmail.com</a>&gt; wrote:<br>
&gt;&gt; Is there a way to obtain more detailed information about the colum=
n, table<br>
&gt;&gt; or parameter that is causing the constraint violation in this scen=
ario? I<br>
&gt;&gt; would greatly appreciate any guidance or advice you could provide =
on this<br>
&gt;&gt; matter<br>
<br>
&gt; What you see is what you get.<br>
<br>
More to the point, you have the wrong mental model: a domain constraint<br>
violation might not be associated with a table column at all.<br><br>
</blockquote><div><br></div><div>I disagree that the mental model is wrong.=
=C2=A0 Asking for better context when constructing rows is a common request=
 not only for domains but even simple data types like dates or numbers.=C2=
=A0 Sure, that added context is not always applicable but when it is the la=
ck of error detail does make life hard.=C2=A0 But it isn=E2=80=99t an easy =
problem to solve either.</div><div><br></div><div>There are existing thread=
s that I may hunt later.=C2=A0 IIRC, you (Tom) even suggested a possible wa=
y forward on this last time it came up.</div><div><br></div><div>David J.</=
div>

--000000000000a23fc805f7cf6521--