Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ueDDj-006Sne-W9 for pgsql-docs@arkaria.postgresql.org; Tue, 22 Jul 2025 13:39:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ueDDi-0089US-2C for pgsql-docs@arkaria.postgresql.org; Tue, 22 Jul 2025 13:39:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ueDDh-0089UH-Qw for pgsql-docs@lists.postgresql.org; Tue, 22 Jul 2025 13:39:50 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ueDDe-000Efw-1y for pgsql-docs@lists.postgresql.org; Tue, 22 Jul 2025 13:39:49 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 56MDdhHT944844; Tue, 22 Jul 2025 09:39:43 -0400 From: Tom Lane To: psimbo@gmail.com cc: pgsql-docs@lists.postgresql.org Subject: Re: Description of disallowed characters in quoted identifiers is incomplete In-reply-to: <175312790281.787.11714206460573047530@wrigleys.postgresql.org> References: <175312790281.787.11714206460573047530@wrigleys.postgresql.org> Comments: In-reply-to PG Doc comments form message dated "Mon, 21 Jul 2025 19:58:22 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <944842.1753191583.1@sss.pgh.pa.us> Date: Tue, 22 Jul 2025 09:39:43 -0400 Message-ID: <944843.1753191583@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Doc comments form writes: > Section 4.1.1 of the documentation claims that "Quoted identifiers can > contain any character, except the character with code zero." However > according to line 105 in src/test/isolation/specscanner.l in the PostgreSQL > source code, new line characters are also disallowed. I'm not sure why you would think that specscanner.l is relevant here. It's for parsing our (rather idiosyncratic) "isolation test" spec files, not SQL. regards, tom lane