"Martin Sullivan" <ms08(at)zois(dot)co(dot)uk> writes:
> The only wrinkle being that to_tsvector needs to be ALTERed
> to IMMUTABLE using the following (as user postgres):
> alter function to_tsvector(regconfig,text) immutable
> alter function to_tsvector(text) immutable
The current settings are intentional: the one-parameter form of
to_tsvector depends on a GUC parameter, so claiming it is immutable
is simply wrong. Please read the documentation concerning how to
use these functions with an index.
regards, tom lane