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

From: Federico <cfederico87(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 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 19:17:49
Message-ID: CAN19dyci7=80q3kLmh=h+B=zYYphcniCvB=AMVLQ3SeREwusYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> 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
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-05-06 00:40:46 BUG #16995: Need repository key to access old distributions from https://apt-archive.postgresql.org/
Previous Message Tom Lane 2021-05-05 17:47:41 Re: BUG #16993: Query Planner does not use index for EXISTS-query on a large table with all equal foreign key values

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2021-05-06 04:17:05 Re: Foreign Keys being able to reference same table not spelled out in documentation
Previous Message Tom Lane 2021-05-05 15:28:31 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error