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

From: Federico Caselli <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:43:00
Message-ID: 546AC8BA-5CF7-4033-BE2B-9612F1671831@hxcore.ol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-docs

<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(at)sss(dot)pgh(dot)pa(dot)us">Tom Lane</a><br><b>Sent: </b>martedì 4 maggio 2021 16:34<br><b>To: </b><a href="mailto:cfederico87(at)gmail(dot)com">Federico</a><br><b>Cc: </b><a href="mailto:pgsql-bugs(at)lists(dot)postgresql(dot)org">pgsql-bugs(at)lists(dot)postgresql(dot)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(at)gmail(dot)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>

Attachment Content-Type Size
unknown_filename text/html 2.8 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Santosh Udupi 2021-05-04 15:08:13 Re: pg_restore - generated column - not populating
Previous Message Tom Lane 2021-05-04 14:34:52 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2021-05-04 18:50:37 Link t the souce code
Previous Message Tom Lane 2021-05-04 14:34:52 Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error