Re: BUG #4187: function to_tsvector not immutable - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4187: function to_tsvector not immutable
Date
Msg-id 15775.1211549102@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4187: function to_tsvector not immutable  ("Martin Sullivan" <ms08@zois.co.uk>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #4188: Array field column (varchar[]) cannot be cast to type "text"
Next
From: "Dennis Gilmore"
Date:
Subject: BUG #4190: sparc64 test suite fails