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
postgresql
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