pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Syntax incorrect for psql 9.6 2+ messages / 2 participants [nested] [flat]
* Syntax incorrect for psql 9.6 @ 2019-09-03 03:33 PG Doc comments form <noreply@postgresql.org> 2019-09-03 13:54 ` Re: Syntax incorrect for psql 9.6 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: PG Doc comments form @ 2019-09-03 03:33 UTC (permalink / raw) To: pgsql-docs@lists.postgresql.org; +Cc: atp@fastmail.fm The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/sql-reindex.html Description: For the REINDEX DATABASE command, the documentation suggests REINDEX DATABASE databaseName, however my experience suggests this does not work; the database name must be quoted: sonarDB=# \c sonarDB; You are now connected to database "sonarDB" as user "sonarUser". sonarDB=# REINDEX DATABASE sonarDB; ERROR: can only reindex the currently open database sonarDB=# REINDEX DATABASE "sonarDB"; REINDEX ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Syntax incorrect for psql 9.6 2019-09-03 03:33 Syntax incorrect for psql 9.6 PG Doc comments form <noreply@postgresql.org> @ 2019-09-03 13:54 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2019-09-03 13:54 UTC (permalink / raw) To: atp@fastmail.fm; +Cc: pgsql-docs@lists.postgresql.org PG Doc comments form <noreply@postgresql.org> writes: > For the REINDEX DATABASE command, the documentation suggests REINDEX > DATABASE databaseName, however my experience suggests this does not work; > the database name must be quoted: > sonarDB=# \c sonarDB; > You are now connected to database "sonarDB" as user "sonarUser". > sonarDB=# REINDEX DATABASE sonarDB; > ERROR: can only reindex the currently open database > sonarDB=# REINDEX DATABASE "sonarDB"; > REINDEX There's nothing wrong with REINDEX; this is just the generic problem that non-lower-case identifiers have to be double-quoted anywhere in SQL. See https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS particularly the last para in 4.1.1. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-09-03 13:54 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-09-03 03:33 Syntax incorrect for psql 9.6 PG Doc comments form <noreply@postgresql.org> 2019-09-03 13:54 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox