MIME-Version: 1.0
References: <CA+j-KtY71coW3-fn5j87R4eKVoPfaA_98brZskWb3qWi=23Buw@mail.gmail.com>
 <4c1c0192-e4f1-4e13-8dae-bfd9bb1801c1@aklaver.com> <CA+j-Ktbnuci7HZY0z9b04Uj50Qy1y8dmvj-zZo6vcnbAAEByaQ@mail.gmail.com>
 <1452427.1748442061@sss.pgh.pa.us>
In-Reply-To: <1452427.1748442061@sss.pgh.pa.us>
From: Richard Zetterberg <richard.zetterberg@googlemail.com>
Date: Fri, 30 May 2025 09:17:02 +0200
Message-ID: <CA+j-KtY9MPzksQjf-a78Vq3kGe8fbWbFOvpQDu_CpXP0QdxAng@mail.gmail.com>
Subject: Re: Changing a varchar(7) domain into text directly in pg_type
To: Tom Lane <tgl@sss.pgh.pa.us>, ronljohnsonjr@gmail.com
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000007eb2606365534c2"
Archived-At: <https://www.postgresql.org/message-id/CA%2Bj-KtY9MPzksQjf-a78Vq3kGe8fbWbFOvpQDu_CpXP0QdxAng%40mail.gmail.com>
Precedence: bulk

--00000000000007eb2606365534c2
Content-Type: text/plain; charset="UTF-8"

Ron, thanks for the feedback and for teaching me a new word (bog-standard).

Tom, thanks for the feedback and extra info about pg_depend. I've tested
simple queries on all of the tables and it seems to be fine. Hopefully
nothing will turn up when we start running the more advanced queries.
Either way, it will be easy to revert to previous backup, since the
database is only used for analysis on static data.

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

<div dir=3D"ltr"><div>Ron, thanks for the feedback and for teaching me a ne=
w word (bog-standard).<br></div><div><br></div><div>Tom, thanks for the fee=
dback and extra info about pg_depend. I&#39;ve tested simple queries on all=
 of the tables and it seems to be fine. Hopefully nothing will turn up when=
 we start running the more advanced queries. Either way, it will be easy to=
 revert to previous backup, since the database is only used for analysis on=
 static data. <br></div><div><br></div></div>

--00000000000007eb2606365534c2--