Horton

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

Federico <cfederico87@gmail.com>

View thread View on postgr.es
From: Federico Caselli <cfederico87@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2021-05-04T14:43:00Z
Lists: pgsql-bugs, pgsql-docs

Attachments

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style></head><body lang=IT link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span lang=EN-US>It may just be me that did not find it.<o:p></o:p></span></p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Best,</p><p class=MsoNormal>Federico</p><p class=MsoNormal><o:p>&nbsp;</o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='border:none;padding:0cm'><b>From: </b><a href="mailto:tgl@sss.pgh.pa.us">Tom Lane</a><br><b>Sent: </b>martedì 4 maggio 2021 16:34<br><b>To: </b><a href="mailto:cfederico87@gmail.com">Federico</a><br><b>Cc: </b><a href="mailto:pgsql-bugs@lists.postgresql.org">pgsql-bugs@lists.postgresql.org</a><br><b>Subject: </b>Re: BUG #16991: regclass is not case sensitive causing &quot;relation does not exist&quot; error</p></div><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Federico &lt;cfederico87@gmail.com&gt; writes:</p><p class=MsoNormal>&gt; I did not come across that documented behavior while searching for regclass</p><p class=MsoNormal>&gt; in the pg docs. The most relevant page I was able to find was the Object</p><p class=MsoNormal>&gt; Identifier Types page that does not mention it.</p><p class=MsoNormal>&gt; I’ll look into proposing a change in that docs page to mention it, if</p><p class=MsoNormal>&gt; that’s the appropriate location for it.</p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>Hmm ... I *thought* it was documented, but perhaps not.  If not,</p><p class=MsoNormal>it's likely that the other reg* types are likewise underdocumented.</p><p class=MsoNormal><o:p>&nbsp;</o:p></p><p class=MsoNormal>                                                regards, tom lane</p><p class=MsoNormal><o:p>&nbsp;</o:p></p></div></body></html>

Commits

  1. Doc: improve and centralize the documentation for OID alias types.