Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Amul Sul <sulamul(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Kirill Reshke <reshkekirill(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Date: 2026-03-31 20:02:22
Message-ID: CADkLM=cXsprF2GvcmqOG+ME_N2iyHNr_--xW-6ZaKd32yF_NzA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 31, 2026 at 10:48 AM jian he <jian(dot)universality(at)gmail(dot)com>
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2026-03-31 20:04:21 Re: docs: warn about post-data-only schema dumps with parallel restore.
Previous Message Tom Lane 2026-03-31 20:00:31 Re: docs: warn about post-data-only schema dumps with parallel restore.