DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

TSearch2 - Upgrade PostgreSQL 8.1 To 8.3

  • submit to reddit
        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 );