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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Дата
Msg-id 41d84eb3471bd6f42384f054c04573ad5c8d7aac.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
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




В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Clarify how triggers relate to transactions