| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Tender Wang <tndrwang(at)gmail(dot)com>, Duncan Sands <duncan(dot)sands(at)deepbluecap(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Attribute of type record has wrong type error with MERGE ... WHEN NOT MATCHED BY SOURCE THEN DELETE |
| Date: | 2025-03-13 15:10:58 |
| Message-ID: | CAEZATCXDGX1M-rWS_paRTbJDMpqCT1OtKZ44ng5H6qxAsSGeSA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, 13 Mar 2025 at 01:39, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-03-13 16:15:33 | Re: Attribute of type record has wrong type error with MERGE ... WHEN NOT MATCHED BY SOURCE THEN DELETE |
| Previous Message | Tom Lane | 2025-03-13 14:43:04 | Re: BUG #18843: ERROR: Input of anonymous composite types is not implemented in array_agg function |