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: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Date: 2021-05-04 14:29:32
Message-ID: CAN19dyfQnRwz=+Ffnr4qfVddZDd7m7LKfuX1PmsFhYY5Z7SpQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

Thanks for the reply. Taking into consideration the schema as in your
solution does indeed explain the current behavior and it makes sense.

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.

Thanks

Federico Caselli

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-05-04 14:34:52 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Previous Message Tom Lane 2021-05-04 13:59:21 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2021-05-04 14:34:52 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Previous Message Tom Lane 2021-05-04 13:59:21 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error