Scott Marlowe <scott.marlowe@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin