MIME-Version: 1.0
References: <0238206d-81c9-4bce-acb4-127fbc4a96ac@dunslane.net>
 <202603301544.utwvuj534m36@alvherre.pgsql>
In-Reply-To: <202603301544.utwvuj534m36@alvherre.pgsql>
From: Ajay Pal <ajay.pal.k@gmail.com>
Date: Tue, 31 Mar 2026 11:44:12 +0530
Message-ID: 
 <CABRHmytPtGAv9weY8_7U_6JPOeYx1+Kq=ojMUYqXuSJB95Hvyg@mail.gmail.com>
Subject: Re: [PATCH] Add support for INSERT ... SET syntax
To: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>
Cc: Andrew Dunstan <andrew@dunslane.net>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
	Suraj Kharage <suraj.kharage@enterprisedb.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CABRHmytPtGAv9weY8_7U_6JPOeYx1%2BKq%3DojMUYqXuSJB95Hvyg%40mail.gmail.com>
Precedence: bulk

Hello all,

I am reporting a server crash encountered while testing the patch
provided by Suraj. The crash is consistently triggered by the query
attached below.

postgres=3D# INSERT INTO emp_test SET (empno,ename)=3D(SELECT 1,'aa');

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Thanks
Ajay

On Mon, Mar 30, 2026 at 9:19=E2=80=AFPM =C3=81lvaro Herrera <alvherre@kuril=
emu.de> wrote:
>
> On 2026-Mar-30, Andrew Dunstan wrote:
>
> > Well, Suraj has kinda beaten me to it, but he didn't invent this syntax=
.
> > Oracle did <https://oracle-base.com/articles/23/non-positional-insert-i=
nto-set-and-insert-into-by-name-clauses-23>
> > and I believe there is a proposal to add it to the standard. (Unlike
> > Suraj's, my WIP patch also supports the INSERT BY NAME variant.)
>
> Hmm, I don't see any WIP patch from you -- are you talking about this
> patch from July 2019?
> https://postgr.es/m/CA+A-St+NntBh2EGu3a0xbVxJFzaeEOn=3DVn_V84OuhM59_HKarQ=
@mail.gmail.com
>
> Funnily enough, we have an even older proposal from 2016,
> https://postgr.es/m/709e06c0-59c9-ccec-d216-21e38cb5ed61@joh.to
>
> It seems this is quite a popular missing feature, as Marko's patch was
> also asked about in February 2019:
> https://postgr.es/m/e58dd487-7ed4-3f95-c63c-24200ed768be@berkvens.net
>
> --
> =C3=81lvaro Herrera        Breisgau, Deutschland  =E2=80=94  https://www.=
EnterpriseDB.com/
>
>