Обсуждение: BUG #13843: Problem with output of an index definition by "pg_restore"

The following bug has been logged on the website:

Bug reference:      13843
Logged by:          Naoki Takami
Email address:      takami@orega.co.jp
PostgreSQL version: 9.4.5
Operating system:   Windows7
Description:

I define the following index.
CREATE INDEX TEST_IDX ... WITH
(tokenizer='TokenBigramSplitSymbolAlphaDigit', normalizer='')
When it was input by "pg_restore" after outputting this by "pg_dump", the
following error occurred.

could not execute query: ERROR:  syntax error at or near ")"
line 1: ...H (tokenizer=TokenBigramSplitSymbolAlphaDigit, normalizer=);

takami@orega.co.jp writes:
> I define the following index.
> CREATE INDEX TEST_IDX ... WITH
> (tokenizer='TokenBigramSplitSymbolAlphaDigit', normalizer='')

This example seems to depend on an index type that doesn't exist in
core Postgres.  Your report would be a lot more helpful if it provided
sufficient detail to recreate the case.

> When it was input by "pg_restore" after outputting this by "pg_dump", the
> following error occurred.
> could not execute query: ERROR:  syntax error at or near ")"
> line 1: ...H (tokenizer=TokenBigramSplitSymbolAlphaDigit, normalizer=);

I think this is fixed by patches that were committed recently to quote
reloptions values ... but it's pretty hard to be sure without enough
detail to recreate the problem.

            regards, tom lane