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

Scott Marlowe <scott.marlowe@gmail.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