Postgres fulltext index

Question

CREATE INDEX message_fulltext_idx ON feedback USING gin(to_tsvector(message));

ERROR:  functions in index predicate must be marked IMMUTABLE

How to avoid this?

kgrittn · Accepted Answer · 2012-04-05 12:40:20Z

28

You need to include the optional config parameter. Without it, the function is not immutable. For example, if you want the standard English text parsing:

CREATE INDEX message_fulltext_idx ON feedback
  USING gin(to_tsvector('english', message));

answered Apr 5, 2012 at 12:40

kgrittn

19.8k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Edmund Over a year ago

This is the correct answer. The first form of to_tsvector will use a default for the config parameter that comes from the setting default_text_search_config. Since that is a changable setting, the function is not immutable. If it were to change, an existing index based on the non-mimmutable function would be silently corrupted. So it's forbidden. See postgresql.org/docs/current/static/….

Collectives™ on Stack Overflow

Postgres fulltext index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related