Re: Attribute of type record has wrong type error with MERGE ... WHEN NOT MATCHED BY SOURCE THEN DELETE - Mailing list pgsql-bugs

On Thu, 13 Mar 2025 at 01:39, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> After some thought, I'm inclined to suggest that we just remove
> the post-rewrite check in the affected branches.
>

I don't really have any better ideas. I guess that if we wanted to
keep this check in back branches, we could copy across the subquery
RTE relids onto the new query, like we do for queryIds. But it would
be somewhat messy, because we'd have to do something like walk each
query pulling a list of its RTE_SUBQUERY RTEs, and then walk both
lists, copying relids over. So maybe not worth the effort.

Regards,
Dean