Re: postgres_fdw could deparse ArrayCoerceExpr - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: postgres_fdw could deparse ArrayCoerceExpr
Date
Msg-id CAPpHfdtoZNDzqm=n9tDFRtCrswJJ533zWmyZ_EZdqew+7EYxeQ@mail.gmail.com
Whole thread Raw
In response to Re: postgres_fdw could deparse ArrayCoerceExpr  (Maxim Orlov <orlovmg@gmail.com>)
Responses Re: postgres_fdw could deparse ArrayCoerceExpr
List pgsql-hackers
Hi Maxim,

On Wed, Jan 29, 2025 at 11:59 AM Maxim Orlov <orlovmg@gmail.com> wrote:
>
> One important note here. This patch will change cast behaviour in case of local and foreign types are mismatched.
> The problem is if we cannot convert types locally, this does not mean that it is also true for a foreign wrapped
data.
> In any case, it's up to the committer to decide whether this change is needed or not.

I have two question regarding this aspect.
1) Is it the same with regular type conversion?
2) Can we fallback to remote type conversion in local type conversion fails?

------
Regards,
Alexander Korotkov
Supabase



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Suggestions for improving \conninfo output in v18
Next
From: Tomas Vondra
Date:
Subject: Re: strange perf regression with data checksums