Mime-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=UTF-8
Date: Wed, 04 Feb 2026 14:54:11 -0300
Message-Id: <DG6DBW8NDTJC.1U9ELI7JCWOEB@gmail.com>
Subject: Re: Show expression of virtual columns in error messages
From: "Matheus Alcantara" <matheusssilv97@gmail.com>
To: "Peter Eisentraut" <peter@eisentraut.org>, "Matheus Alcantara"
 <matheusssilv97@gmail.com>, <pgsql-hackers@lists.postgresql.org>
References: <DG5DV8SED62G.2WFJB46D7WIT8@gmail.com>
 <7c18e854-0ddb-4670-b0c4-f2541b5edd91@eisentraut.org>
In-Reply-To: <7c18e854-0ddb-4670-b0c4-f2541b5edd91@eisentraut.org>
Archived-At: 
 <https://www.postgresql.org/message-id/DG6DBW8NDTJC.1U9ELI7JCWOEB%40gmail.com>
Precedence: bulk

On Wed Feb 4, 2026 at 11:57 AM -03, Peter Eisentraut wrote:
> On 03.02.26 15:06, Matheus Alcantara wrote:
>> The attached patch changes this behavior to show the virtual column
>> expression instead:
>>=20
>>    ERROR:  new row for relation "t" violates check constraint "t_c_check=
"
>>    DETAIL:  Failing row contains (5, 10, a * 2).
>
> Could be useful, but in this context you don't know which column is "a"?

I agree but we at least show more information to the user. The user may
still need to check the table definition to understand the constraint or
to get the column ordering of the table to understand what the value of
"a" is being used to compute the expression.=20

If the statement declare the columns that the values are referecing this
could be easier to know (e.g INSERT INTO t(a, b) VALUES (5, 10)) but the
user may still need to check the table definition to understand the
constraint.

I see this patch as a way to at least give more information to user
about the error.

Another possibility would be to get the actual values of "a" for example
and show it on the error message, e.g:

    ERROR:  new row for relation "t" violates check constraint "t_c_check"
    DETAIL:  Failing row contains (5, 10, 5 * 2).

--
Matheus Alcantara
EDB: https://www.enterprisedb.com