pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dennis <dennis@iletsel.nl>
Cc: pgsql-general@postgresql.org
Subject: Re: Version 16.x search_path behavior change?
Date: Sun, 24 Dec 2023 10:43:35 -0500
Message-ID: <1611874.1703432615@sss.pgh.pa.us> (raw)
In-Reply-To: <f2b90664-32e8-4e2a-906b-099fe8692739@iletsel.nl>
References: <f2b90664-32e8-4e2a-906b-099fe8692739@iletsel.nl>

Dennis <dennis@iletsel.nl> writes:
> The 16.x documentation still says the following:

> However, you can explicitly place |pg_catalog| at the end of your search 
> path if you prefer to have user-defined names override built-in names.

It does work that way, for ordinary names.  JSON_OBJECT is special
because it has special calling syntax (thank you, SQL committee)
and the grammar productions for that always resolve it as the
built-in function.  You could override things by writing explicitly
"myschema.json_object(...)" but I imagine you don't want to.

I'm not sure if this should be considered a bug or not.  It looks
like we've gone out of our way to avoid capturing some other
comparable cases such as OVERLAY and SUBSTRING, if they aren't
actually written with special syntax.  Don't know offhand if it's
practical to handle JSON_OBJECT similarly, or whether it'd really
make sense to have an exception for that.

			regards, tom lane





view thread (2+ messages)

Message-ID: <1611874.1703432615@sss.pgh.pa.us>
Permalink:  ../1611874.1703432615@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1611874.1703432615@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tgl@sss.pgh.pa.us, dennis@iletsel.nl
  Subject: Re: Version 16.x search_path behavior change?
  In-Reply-To: <1611874.1703432615@sss.pgh.pa.us>
  References: <f2b90664-32e8-4e2a-906b-099fe8692739@iletsel.nl> <1611874.1703432615@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox