agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedDescription of disallowed characters in quoted identifiers is incomplete
3+ messages / 3 participants
[nested] [flat]
* Description of disallowed characters in quoted identifiers is incomplete
@ 2025-07-21 19:58 PG Doc comments form <noreply@postgresql.org>
2025-07-22 09:02 ` Re: Description of disallowed characters in quoted identifiers is incomplete Laurenz Albe <laurenz.albe@cybertec.at>
2025-07-22 13:39 ` Re: Description of disallowed characters in quoted identifiers is incomplete Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: PG Doc comments form @ 2025-07-21 19:58 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: psimbo@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-syntax-lexical.html
Description:
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Description of disallowed characters in quoted identifiers is incomplete
2025-07-21 19:58 Description of disallowed characters in quoted identifiers is incomplete PG Doc comments form <noreply@postgresql.org>
@ 2025-07-22 09:02 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2025-07-22 09:02 UTC (permalink / raw)
To: psimbo@gmail.com; pgsql-docs@lists.postgresql.org
On Mon, 2025-07-21 at 19:58 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/17/sql-syntax-lexical.html
> Description:
>
> 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.
psql (18beta2)
Type "help" for help.
test=> CREATE TABLE "new
line" ();
CREATE TABLE
test=> \dt new*
List of tables
Schema │ Name │ Type │ Owner
═════════╪════════╪═══════╪═════════
laurenz │ new ↵│ table │ laurenz
│ line │ │
laurenz │ newtab │ table │ laurenz
(2 rows)
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Description of disallowed characters in quoted identifiers is incomplete
2025-07-21 19:58 Description of disallowed characters in quoted identifiers is incomplete PG Doc comments form <noreply@postgresql.org>
@ 2025-07-22 13:39 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2025-07-22 13:39 UTC (permalink / raw)
To: psimbo@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-07-22 13:39 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-07-21 19:58 Description of disallowed characters in quoted identifiers is incomplete PG Doc comments form <noreply@postgresql.org>
2025-07-22 09:02 ` Laurenz Albe <laurenz.albe@cybertec.at>
2025-07-22 13:39 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox