Deparse of index with period (.) in name leads to syntax error

[lwithers]

Hi,

If I parse and then de-parse the following statement:

CREATE INDEX "foo.index" ON foo USING btree (bar)

then I end up with a result where the index name is unquoted, which is a syntax error:

CREATE INDEX foo.index ON foo USING btree (bar)

PostgresQL (tested on 10.23 and 15.1) reports:

postgres=# CREATE INDEX foo.index ON foo USING btree (bar);
ERROR: syntax error at or near "." (SQLSTATE 42601)

[lfittl]

@lwithers Thanks for the report - that's an oversight in the deparser code, see pganalyze/libpg_query#182