From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Geoghegan <pg@bowt.ie>
cc: yaser.amiri95@gmail.com,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17445: "ON CONFLICT" has different behaviors when its param
 is passed with prepared stmt or hard coded
In-reply-to: 
 <CAH2-Wzmbdn1DdJoY5G-_7WuwiqLJM8tWdJaMMsPX8gimLPSdZg@mail.gmail.com>
References: <17445-fb74db6348391e85@postgresql.org>
 <2405214.1647901437@sss.pgh.pa.us>
 <CAH2-WznReJ_0FbTXJHV=zrfS6G7mOhTQLL5CqGJ5mJp9u8yAnA@mail.gmail.com>
 <2409082.1647903795@sss.pgh.pa.us>
 <CAH2-Wzmbdn1DdJoY5G-_7WuwiqLJM8tWdJaMMsPX8gimLPSdZg@mail.gmail.com>
Comments: In-reply-to Peter Geoghegan <pg@bowt.ie>
	message dated "Mon, 21 Mar 2022 16:14:21 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2411143.1647905253.1@sss.pgh.pa.us>
Date: Mon, 21 Mar 2022 19:27:33 -0400
Message-ID: <2411144.1647905253@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2411144.1647905253%40sss.pgh.pa.us>
Precedence: bulk

Peter Geoghegan <pg@bowt.ie> writes:
> On Mon, Mar 21, 2022 at 4:03 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Perhaps a specific error message would be worth the trouble.

> I'm not sure how difficult it would be offhand, so I can't commit to it now.

Searching that expression tree for an EXTERN Param surely wouldn't take
much code.  What's not clear to me though is whether that's the full
extent of problematic cases.  (Picking a user-friendly wording for the
error message might be hard too.)

			regards, tom lane