Re: User defined functions... - Found to be tsearch

Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> tsearch is included from 8.3 onwards. 8.2 does not have it built it.
> You'd have to go into the contrib directory and build it (if you built
> pgsql from source) and then install it from there. But upgrading from
> 8.2 with tsearch added on to 8.3 is a bit of a pain, so I'd strongly
> suggest just going to 8.3 if you can. If 8.2.4 is missing a contrib
> dir, and you installed from packages it's likely you didn't install
> the 8.2.4-contrib package.

No, Carol's problem is she's trying to load 8.2-vintage tsearch
configuration tables into an 8.3 installation. That won't work
unless she first installs the *8.3* contrib/tsearch2 compatibility
module. See its documentation.

regards, tom lane