From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Federico <cfederico87@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Date: Wed, 05 May 2021 09:32:14 +0200
Message-ID: <41d84eb3471bd6f42384f054c04573ad5c8d7aac.camel@cybertec.at> (raw)
In-Reply-To: <3976561.1620170328@sss.pgh.pa.us>
References: <16991-bcaeaafa17e0a723@postgresql.org>
<3896142.1620136761@sss.pgh.pa.us>
<CAN19dyfQnRwz=+Ffnr4qfVddZDd7m7LKfuX1PmsFhYY5Z7SpQw@mail.gmail.com>
<3904665.1620138892@sss.pgh.pa.us>
<3976561.1620170328@sss.pgh.pa.us>
On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote:
> [ redirecting to pgsql-docs list ]
>
> I wrote:
> > Federico <cfederico87@gmail.com> writes:
> > > I did not come across that documented behavior while searching for regclass
> > > in the pg docs. The most relevant page I was able to find was the Object
> > > Identifier Types page that does not mention it.
> > > I'll look into proposing a change in that docs page to mention it, if
> > > that's the appropriate location for it.
> > Hmm ... I *thought* it was documented, but perhaps not. If not,
> > it's likely that the other reg* types are likewise underdocumented.
>
> So what I was remembering was some text in the section about sequence
> functions. That probably seemed appropriate when they were the only
> real use of regclass; but these days we have regclass-accepting functions
> all over, not to mention other OID alias types. I propose the attached
> patch to move this info into the "Object Identifier Types" section.
That patch looks good to me.
I think it is an improvement to have that discussed under "data types".
Yours,
Laurenz Albe
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 using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: laurenz.albe@cybertec.at, tgl@sss.pgh.pa.us, cfederico87@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
In-Reply-To: <41d84eb3471bd6f42384f054c04573ad5c8d7aac.camel@cybertec.at>
* 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