RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error - Mailing list pgsql-bugs

From Federico
Subject RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Date
Msg-id CAN19dyfQnRwz=+Ffnr4qfVddZDd7m7LKfuX1PmsFhYY5Z7SpQw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs

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

 

 

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error
Next
From: Tom Lane
Date:
Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error