PostgreSQL Invalid Value for Parameter Warning

Posted by gvkv on Stack Overflow See other posts from Stack Overflow or by gvkv
Published on 2010-05-24T13:57:43Z Indexed on 2010/05/24 14:01 UTC
Read the original article Hit count: 467

Filed under:

In PostgreSQL 8.4.3, I get this error when logging on to one of my databases (adus):

WARNING:  invalid value for parameter "default_text_search_config": "tsc_markets"

which makes sense since executing the command \dF does not list any such configuration (and only lists the defaults). However, when I ask psql to show me the current value:

adus=# show default_text_search_config;

I get

 default_text_search_config
----------------------------
 pg_catalog.english
(1 row)

In addition, the postgresql.config file has the entry:

# default configuration for text search
default_text_search_config = 'pg_catalog.english'

plus, there is only one (user) defined schema that I use (also called adus) in this database.

What's going on?

© Stack Overflow or respective owner

Related posts about postgresql