On Wed, Feb 05, 2025 at 01:36:57PM -0600, Sami Imseih wrote:
>> so the only reason I can see
>> for not back-patching it is that it could lead to somewhat widespread
>> breakage for existing scripts, etc. which are arguably kind-of working
>> today.
>
> That is my thought for not backpatching. It's not breaking the COPY
> command, it's just not applying an optimization.
>
> Let's see what others think.
Given we don't have any other reports or opinions, I'm probably just going
to apply the patch to v18. That leaves the door open to back-patch later.
The next minor release is next week, anyway, and this doesn't seem urgent.
I did find one other thread that mentions this behavior [0]. They floated
the idea of blocking COPY FREEZE on foreign tables, but the topic fizzled
out in indecision. *shrug*
[0] https://postgr.es/m/20181219023814.GA6577%40paquier.xyz
--
nathan
