Re: Description of disallowed characters in quoted identifiers is incomplete

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: psimbo(at)gmail(dot)com
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Description of disallowed characters in quoted identifiers is incomplete
Date: 2025-07-22 13:39:43
Message-ID: 944843.1753191583@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

PG Doc comments form <noreply(at)postgresql(dot)org> 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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2025-07-22 23:39:57 Suggestion: Change link in tutorial to go to chapter 16 for binary installation
Previous Message Laurenz Albe 2025-07-22 09:02:24 Re: Description of disallowed characters in quoted identifiers is incomplete