Skip site navigation (1) Skip section navigation (2)

BUG #4187: function to_tsvector not immutable

From: "Martin Sullivan" <ms08(at)zois(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4187: function to_tsvector not immutable
Date: 2008-05-23 08:30:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4187
Logged by:          Martin Sullivan
Email address:      ms08(at)zois(dot)co(dot)uk
PostgreSQL version: 8.3
Operating system:   Fedora Core 9
Description:        function to_tsvector not immutable

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.


pgsql-bugs by date

Next:From: Thomas H.Date: 2008-05-23 09:51:52
Subject: Re: BUG #4186: set lc_messages does not work
Previous:From: Euler Taveira de OliveiraDate: 2008-05-23 04:57:33
Subject: Re: BUG #4186: set lc_messages does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group