Re: BUG #4187: function to_tsvector not immutable

"Martin Sullivan" <ms08@zois.co.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