MIME-Version: 1.0
References: <CAAZ6SnzFLQzraWws7_ZKjGtJ+XNK+Hz9DStGbEPzzHKjUXqELQ@mail.gmail.com>
 <13cb8c5c-84f1-4bf8-983a-268969bfcc25@aklaver.com>
In-Reply-To: <13cb8c5c-84f1-4bf8-983a-268969bfcc25@aklaver.com>
From: Stuart Campbell <stuart.campbell@ridewithvia.com>
Date: Thu, 8 Jan 2026 08:59:52 +1100
Message-ID: <CAAZ6SnweFKohrh9UecMLUtR7CJ5d=qNfjbfPyAJD_-b5O1XM8A@mail.gmail.com>
Subject: Re: Unexpected modification of check constraint definition
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000036e22a0647d36acf"
Archived-At: <https://www.postgresql.org/message-id/CAAZ6SnweFKohrh9UecMLUtR7CJ5d%3DqNfjbfPyAJD_-b5O1XM8A%40mail.gmail.com>
Precedence: bulk

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

On Thu, Jan 8, 2026 at 2:24=E2=80=AFAM Adrian Klaver <adrian.klaver@aklaver=
.com>
wrote:

> https://www.postgresql.org/docs/current/datatype-character.html
>
> "text is PostgreSQL's native string data type, in that most built-in
> functions operating on strings are declared to take or return text not
> character varying. For many purposes, character varying acts as though
> it were a domain over text."


Thanks. It seems like I should generally prefer to use text over varchar.
(I've read advice along those lines elsewhere.)


> When you did the dump/restore cycles where they from and to the same
> Postgres version/instance?


Yes. In the example I provided, that was all from the same Postgres 16.4
instance.

Regards,
Stuart

--=20
This communication and any attachments may contain confidential information=
=20
and are intended to be viewed only by the intended recipients. If you have=
=20
received this message in error, please notify the sender immediately by=20
replying to the original message and then delete all copies of the email=20
from your systems.


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

<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">On Thu, Jan 8, 2026 at 2:24=E2=80=AFAM Adrian=
 Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@akla=
ver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">
<a href=3D"https://www.postgresql.org/docs/current/datatype-character.html"=
 rel=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/curre=
nt/datatype-character.html</a><br>
<br>
&quot;text is PostgreSQL&#39;s native string data type, in that most built-=
in <br>
functions operating on strings are declared to take or return text not <br>
character varying. For many purposes, character varying acts as though <br>
it were a domain over text.&quot;</blockquote><div><br></div><div>Thanks. I=
t seems like I should generally prefer to use text over varchar. (I&#39;ve =
read advice along those lines elsewhere.)</div><div>=C2=A0</div><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex">
When you did the dump/restore cycles where they from and to the same <br>
Postgres version/instance?</blockquote><div><br></div><div>Yes. In the exam=
ple I provided, that was all from the same Postgres 16.4 instance.=C2=A0</d=
iv><div><br></div><div>Regards,</div><div>Stuart</div></div></div>

<br>
<div>This communication and any attachments may contain confidential inform=
ation and are intended to be viewed only by the intended recipients. If you=
 have received this message in error, please notify the sender immediately =
by replying to the original message and then delete all copies of the email=
 from your systems.</div><div><br></div><div><br></div>
--00000000000036e22a0647d36acf--