"Martin Sullivan" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs