MIME-Version: 1.0
References: 
 <CANKisB3AG6JK1tCMp4myj75tF3t93pEK_ojECdJ=Fnin-E+J_A@mail.gmail.com>
 <165553.1778680299@sss.pgh.pa.us>
In-Reply-To: <165553.1778680299@sss.pgh.pa.us>
From: Marcelo Lauxen <marcelolauxen16@gmail.com>
Date: Wed, 13 May 2026 11:25:47 -0300
Message-ID: 
 <CANKisB3F+=yZm-gK1RzcD761qUT56JT0LVOwe84Zg-QqBHZc3w@mail.gmail.com>
Subject: 
 =?UTF-8?B?UmU6IHBnX2dldF9pbmRleGRlZigpIG91dHB1dCBub3QgaWRlbXBvdGVudCBmb3IgcGFydA==?=
	=?UTF-8?B?aWFsIGluZGV4ZXMgd2l0aCBBTEwoQVJSQVlb4oCmXSk6OnRleHRbXQ==?=
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002d894c0651b3c22c"
Archived-At: 
 <https://www.postgresql.org/message-id/CANKisB3F%2B%3DyZm-gK1RzcD761qUT56JT0LVOwe84Zg-QqBHZc3w%40mail.gmail.com>
Precedence: bulk

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

Gotcha, it wasn't clear to me that this was never guaranteed. I will change
the type of this column to text to resolve this.

Appreciate the quick response!

Regards,
Marcelo

On Wed, May 13, 2026 at 10:51=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wrote=
:

> Marcelo Lauxen <marcelolauxen16@gmail.com> writes:
> > *PostgreSQL version*: 18.3 (Homebrew) on aarch64-apple-darwin24.6.0
> > *pg_get_indexdef()* produces SQL that, when executed, yields a differen=
t
> > pg_get_indexdef() output. This means a pg_dump =E2=86=92 pg_restore cyc=
le
> silently
> > changes the deparsed form of partial index WHERE clauses that use NOT I=
N
> > (...) on a varchar column, causing cosmetic drift in tools that compare
> > index definitions (e.g. ORM schema dumps, annotation generators).
>
> You are assuming a property that we've never guaranteed and don't plan
> to start guaranteeing, ie that the output of expression decompilation
> matches the input even in semantically-insignificant details.
>
> My own advice about how to fix this particular example is not to use
> varchar --- especially not unconstrained varchar, which doesn't even
> have the thin excuse of being spec-compliant.  Postgres' native string
> type is text.
>
>                         regards, tom lane
>

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

<div dir=3D"ltr">Gotcha, it wasn&#39;t clear to me that this was never guar=
anteed. I will change the type of this column to text to resolve this.=C2=
=A0<div><br></div><div>Appreciate the quick response!=C2=A0</div><div><br><=
/div><div>Regards,=C2=A0</div><div>Marcelo</div></div><br><div class=3D"gma=
il_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On We=
d, May 13, 2026 at 10:51=E2=80=AFAM Tom Lane &lt;<a href=3D"mailto:tgl@sss.=
pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">Marcelo Lauxen &lt;<a href=3D"mailto:marcelolau=
xen16@gmail.com" target=3D"_blank">marcelolauxen16@gmail.com</a>&gt; writes=
:<br>
&gt; *PostgreSQL version*: 18.3 (Homebrew) on aarch64-apple-darwin24.6.0<br=
>
&gt; *pg_get_indexdef()* produces SQL that, when executed, yields a differe=
nt<br>
&gt; pg_get_indexdef() output. This means a pg_dump =E2=86=92 pg_restore cy=
cle silently<br>
&gt; changes the deparsed form of partial index WHERE clauses that use NOT =
IN<br>
&gt; (...) on a varchar column, causing cosmetic drift in tools that compar=
e<br>
&gt; index definitions (e.g. ORM schema dumps, annotation generators).<br>
<br>
You are assuming a property that we&#39;ve never guaranteed and don&#39;t p=
lan<br>
to start guaranteeing, ie that the output of expression decompilation<br>
matches the input even in semantically-insignificant details.<br>
<br>
My own advice about how to fix this particular example is not to use<br>
varchar --- especially not unconstrained varchar, which doesn&#39;t even<br=
>
have the thin excuse of being spec-compliant.=C2=A0 Postgres&#39; native st=
ring<br>
type is text.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--0000000000002d894c0651b3c22c--