MIME-Version: 1.0
References: 
 <CADkLM=fv1JfY4Ufa-jcwwNbjQixNViskQ8jZu3Tz_p656i_4hQ@mail.gmail.com>
 <CADkLM=cZ7N+f4Bj-8MiccFcTASjBB2r1_s3BD9OFbbQOwK01cg@mail.gmail.com>
 <CACJufxE7yoH42juViFvYuCQMPwXMWxDVwiugs-BW+N4oUXB=1w@mail.gmail.com>
 <CADkLM=dFZ8-mBJDkiZZ4JadnJy8zLExUoo_b1FOs2Ozrtge=gQ@mail.gmail.com>
 <CACJufxHynx40aHHUCR4wZh1qnL=X0yw6baW4Z-+vkUgT0OhjOg@mail.gmail.com>
 <CADkLM=eCPiVhGKcbNW5bUEYpozUaKNXjd_UmBVR256p2zWtYQQ@mail.gmail.com>
 <CACJufxH4LrCpL63SRYO3zVk46YdD4--VYQoBL7GmHmCm=NCAJQ@mail.gmail.com>
 <CADkLM=cmv_bmxBe8KmZd6rEgiqSdoDfHnJa63u7rdRuAsqOwDA@mail.gmail.com>
 <CACJufxGbw9iNT8QVm4QD9cPFKnDnvDBQp7AGxkoqDa-JjzVXmg@mail.gmail.com>
 <CACJufxFkLLuX1VJ-J3fppCr37PHtxkvwyd_e4zNd+VYK0v0gnQ@mail.gmail.com>
 <5ae9578e-f25e-49c5-97ab-ad27bc2050b5@eisentraut.org>
 <CACJufxHx-UfprE6P4_ZB_cOYktHd4pLMNx=jWJFOGGGFj2YZWQ@mail.gmail.com>
 <CACJufxH_1EtEBMb0JvxaM3Gmnt33HYrS37m5eYjJ_OfBkMVFJg@mail.gmail.com>
 <CACJufxHGox47X4zNtVeNw7H=SZ7ATAAD5SEYpvxa2o5mPV0XCA@mail.gmail.com>
 <5221f892-e1d5-4943-a3dc-5c9c7bdf4924@eisentraut.org>
 <CAAJ_b959dfJsorK+_vPdVa8F3QYPdOnb-HzJY8oQQR91N9Tq2A@mail.gmail.com>
 <CACJufxFOQkmH9KeQNTD0qASbL3i03cLeoyVZdcZ8Fm0rk6eJ5Q@mail.gmail.com>
 <CACJufxEUr33CoQMsZdEehNU7wj_QOiyk8VW=W+aB03PF2J_qKQ@mail.gmail.com>
 <CACJufxGx_XDHq1btNj=ZrBjwd0skeWFJQLMGqSR-pHw-kuYRnQ@mail.gmail.com>
In-Reply-To: 
 <CACJufxGx_XDHq1btNj=ZrBjwd0skeWFJQLMGqSR-pHw-kuYRnQ@mail.gmail.com>
From: Corey Huinker <corey.huinker@gmail.com>
Date: Tue, 31 Mar 2026 16:02:22 -0400
Message-ID: 
 <CADkLM=cXsprF2GvcmqOG+ME_N2iyHNr_--xW-6ZaKd32yF_NzA@mail.gmail.com>
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User
 Functions
To: jian he <jian.universality@gmail.com>
Cc: Amul Sul <sulamul@gmail.com>, Peter Eisentraut <peter@eisentraut.org>,
	Kirill Reshke <reshkekirill@gmail.com>,
 Vik Fearing <vik@postgresfriends.org>,
	Isaac Morland <isaac.morland@gmail.com>, pgsql-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d6e66e064e5772af"
Archived-At: 
 <https://www.postgresql.org/message-id/CADkLM%3DcXsprF2GvcmqOG%2BME_N2iyHNr_--xW-6ZaKd32yF_NzA%40mail.gmail.com>
Precedence: bulk

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

On Tue, Mar 31, 2026 at 10:48=E2=80=AFAM jian he <jian.universality@gmail.c=
om>
wrote:

> Hi.
> I've incorporated the changes you sent me off-list.
> The attached v1 no-cfbot is your proposed change.
> I also did some minor comments adjustments.
>

The remaining patches continue to work for me. I hope we can get all of
this into 19, but if we can't I think it would be ok to limit src/dest type
combinations to those that can be handled by CoerceViaIO, at least for 19.
I think the vast majority of the usage of this function will be mass ETLs
where data is first loaded into a table of all text.

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Mar 31,=
 2026 at 10:48=E2=80=AFAM jian he &lt;<a href=3D"mailto:jian.universality@g=
mail.com">jian.universality@gmail.com</a>&gt; wrote:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex">Hi.<br>
I&#39;ve incorporated the changes you sent me off-list.<br>
The attached v1 no-cfbot is your proposed change.<br>
I also did some minor comments adjustments.<br></blockquote><div><br></div>=
<div>The remaining patches continue to work for me. I hope we can get all o=
f this into 19, but if we can&#39;t I think it would be ok to limit src/des=
t type combinations to those that can be handled by CoerceViaIO, at least f=
or 19. I think the vast majority of the usage of this function will be mass=
 ETLs where data is first loaded into a table of all text.</div><div>=C2=A0=
</div></div></div>

--000000000000d6e66e064e5772af--