Horton

Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, borz_off@cs.msu.su, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2022-08-12T00:58:28Z
Lists: pgsql-bugs 
On Fri, Aug 12, 2022 at 1:08 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > Here's a patch.  I kept the location in the CTE bit, because it's better
> > than nothing.  No location hint is possible for the COPY one, as far as
> > I can see.
>
> OK by me.


+1. The patch looks good to me.

Thanks
Richard

Commits

  1. Reject MERGE in CTEs and COPY