TSearch2 - Upgrade PostgreSQL 8.1 To 8.3

• Tweet
• 

        I had terrible trouble getting my tsearch to work after migrating from 8.1 to 8.3.  If you are getting errors like:

ERROR:  text search configuration "default" does not exist

you need to create a "default" configuration.  
Use the following to get a list of configurations:

postgres=# \dF

Now create a configuration copying it from the language configuration of your choice like so:

postgres=# CREATE TEXT SEARCH CONFIGURATION public.default ( COPY = pg_catalog.english );

Tags:
• PostgreSQL
• tsearch2