Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Thanks for the quick resolution. Best, Federico Ps: sorry for the previous messages in html, I had not realized that the client I was using were sending the replies like that. On Wed, 5 May 2021 at 17:28, Tom Lane wrote: > Laurenz Albe writes: > > On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote: > >> 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". > > Pushed, thanks for reviewing. > > regards, tom lane >
RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
The patch is also clear for me, thanks for working on it. Best,Federico From: Laurenz AlbeSent: mercoledì 5 maggio 2021 09:32To: Tom Lane; FedericoCc: pgsql-docs@lists.postgresql.orgSubject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote:> [ redirecting to pgsql-docs list ]> > I wrote:> > Federico 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
