| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |