Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Federico <cfederico87(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Date: 2021-05-05 07:32:14
Message-ID: 41d84eb3471bd6f42384f054c04573ad5c8d7aac.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote:
> [ redirecting to pgsql-docs list ]
>
> I wrote:
> > Federico <cfederico87(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Federico Caselli 2021-05-05 07:53:41 RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Previous Message Tom Lane 2021-05-04 23:18:48 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

Browse pgsql-docs by date

  From Date Subject
Next Message Federico Caselli 2021-05-05 07:53:41 RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Previous Message Tom Lane 2021-05-04 23:18:48 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error