Re: default_text_search_config and expression indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: default_text_search_config and expression indexes
Date
Msg-id 12437.1187128701@sss.pgh.pa.us
Whole thread Raw
In response to Re: default_text_search_config and expression indexes  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: default_text_search_config and expression indexes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Bruce Momjian escribi�:
>> What has really hurt the default GUC idea is how to do restores from a
>> pg_dump.

> I guess what should happen is that pg_dump should include a
> SET default_text_search_config = 'foo'
> just before the CREATE INDEX, like we do for other variables.

The nasty cases are in data-only dumps, that is, where you're trying to
load data into a table with pre-existing indexes or triggers.  A SET
like the above is at least as likely to be wrong as right, if the index
or trigger depends on it to tell it what to do.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: tsearch2 in PostgreSQL 8.3?
Next
From: Kris Jurka
Date:
Subject: CVS corruption/mistagging?