The following bug has been logged online: Bug reference: 4187 Logged by: Martin Sullivan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Fedora Core 9 Description: function to_tsvector not immutable Details:
Postgres 8.3 now supports tsearch2 as standard and it's built into the distribution. So, to_tsvector, tsvector, the '@@' operator &al are readily available. 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 This is needed to allow CREATE INDEX to work with these functions and the access methods GIN and GIST, else you get an error message about indexes requiring immutable functions. It should be added that the to_tsvector are declared immutable in the 8.2 contrib distribution. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
