Re: BUG #13843: Problem with output of an index definition by "pg_restore"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: takami(at)orega(dot)co(dot)jp
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13843: Problem with output of an index definition by "pg_restore"
Date: 2016-01-05 04:20:55
Message-ID: 22614.1451967655@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

takami(at)orega(dot)co(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-01-05 07:52:49 Re: BUG #13822: Slave terminated - WAL contains references to invalid page
Previous Message Jarred Ward 2016-01-05 03:41:36 Copy paste typo in bug #13844