PostgreSQL Invalid Value for Parameter Warning
- by gvkv
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?