Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1leN2T-0006NQ-JM for pgsql-docs@arkaria.postgresql.org; Wed, 05 May 2021 19:18:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1leN2R-0004g0-7K for pgsql-docs@arkaria.postgresql.org; Wed, 05 May 2021 19:18:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1leN2Q-0004fs-UB for pgsql-docs@lists.postgresql.org; Wed, 05 May 2021 19:18:27 +0000 Received: from mail-qk1-x732.google.com ([2607:f8b0:4864:20::732]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1leN2J-0003ZV-Kg for pgsql-docs@lists.postgresql.org; Wed, 05 May 2021 19:18:25 +0000 Received: by mail-qk1-x732.google.com with SMTP id x8so2694344qkl.2 for ; Wed, 05 May 2021 12:18:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=MEMLnmEEGRSFoyTbW/wPmS2no8cYxGOmMfwxdYwwxsg=; b=WrGQPAK6BaCeYBQa+gjn6V1ZKce5eTtR92RakZrHjAHRQojG329PwxKTxXo+8li/CQ B/3i3JnWZUWqvIyFjyDFxBYjnk32xYTPuFb48BnYmCgfIytHtNodKGA5JWtO8fDXGIpA ZGGiuvU70rcEX8aGjYbzXjffShENX13KCNLGm4EweNm3jI8uON8G1TJxrerEf8clq9Jp jhQjMQB1q7vgMtxPQ3q70T/nxNJaI4StSPLsPR79kGDANikX5f0jV8584x73Xy59L/b0 Ln2aZQjEgM2Hbhz+eMTC7pOHofH/1OXM2eFIdGvppv4D2vylMz/Tk0fanaug2cXjLp32 cj7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=MEMLnmEEGRSFoyTbW/wPmS2no8cYxGOmMfwxdYwwxsg=; b=jd6XddPdqFu2QK4CSO8g8FVPOAkGQq+gq2Tp/6V9CrdlfUPDD35vAa+7N6oazQJC7H SvioROXFhgnbQiSP6k9XUcfRVqfYcT5D4CIhN47zvLNlhUB6PYhRHZyM8dN0YINTkxTi Qhvx4DhUdUmojVTUiT3PfGrVNfQI5xKxxa0sVg8NTpjILFUPTqBZJyXAHxWI9veOOWea UQZrG7S0o456YVOO8hdeaZ5y9g4ofK5rzIO9+5SW80ZkciCMqeaaHHEfc7paV50mYi88 +tRZOdNxQf7xRVg3CLT8t/w42oMRwfojbAxyG1dq704HzI7KnMJXKz9oyfqyiNrqqGgs +4gA== X-Gm-Message-State: AOAM5336jgMt+5R6y+ETDUeCtclkz7e0aNjSg3RJOuXNH0W5Zmyrwbds OXI8Uaz2pYzOraipyVx1/QSsXWFu26CGp6FCDe0= X-Google-Smtp-Source: ABdhPJx3mvS6bHtRwk5wbp9CYBMn8UWUUvUPlznioXYhEIBeYtwbIlCshwiGUPFYeV+SqICqixYuilZRDCFLkD7mEJM= X-Received: by 2002:a37:9e44:: with SMTP id h65mr279753qke.297.1620242298374; Wed, 05 May 2021 12:18:18 -0700 (PDT) MIME-Version: 1.0 References: <16991-bcaeaafa17e0a723@postgresql.org> <3896142.1620136761@sss.pgh.pa.us> <3904665.1620138892@sss.pgh.pa.us> <3976561.1620170328@sss.pgh.pa.us> <41d84eb3471bd6f42384f054c04573ad5c8d7aac.camel@cybertec.at> <4026666.1620228511@sss.pgh.pa.us> In-Reply-To: <4026666.1620228511@sss.pgh.pa.us> From: Federico Date: Wed, 5 May 2021 21:17:49 +0200 Message-ID: Subject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error To: Tom Lane Cc: Laurenz Albe , pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a50ed505c19a0e5b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a50ed505c19a0e5b Content-Type: text/plain; charset="UTF-8" Thanks for the quick resolution. Best, Federico Ps: sorry for the previous messages in html, I had not realized that the client I was using were sending the replies like that. On Wed, 5 May 2021 at 17:28, Tom Lane wrote: > Laurenz Albe writes: > > On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote: > >> 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". > > Pushed, thanks for reviewing. > > regards, tom lane > --000000000000a50ed505c19a0e5b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for the quick resolution.

=
Best,
Federico

Ps: sorry for the pr= evious messages in html, I had not realized that the client I was using wer= e sending the replies like that.

On Wed, 5 May 2021 at 17:28, Tom = Lane <tgl@sss.pgh.pa.us> wro= te:
Laurenz Albe= <laurenz.= albe@cybertec.at> writes:
> On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote:
>> So what I was remembering was some text in the section about seque= nce
>> functions.=C2=A0 That probably seemed appropriate when they were t= he only
>> real use of regclass; but these days we have regclass-accepting fu= nctions
>> all over, not to mention other OID alias types.=C2=A0 I propose th= e attached
>> patch to move this info into the "Object Identifier Types&quo= t; section.

> That patch looks good to me.
> I think it is an improvement to have that discussed under "data t= ypes".

Pushed, thanks for reviewing.

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 regards, tom lane
--000000000000a50ed505c19a0e5b--