1) Require the configuration to be always specified. The problem with
this is that casting (::tsquery) and operators (@@) have no way to
specify a configuration.
it's not comfortable for most often cases
2) Use a GUC that you can set for the configuration, and perhaps
default it if possible to match the locale. Is the default affected by
Right now it works so
How do we make sure that any index that is accessed is using the same
configuration that is being used by the query, e.g. ::tsquery? Do we
have to store the configuration name in the index and somehow throw an
error if it doesn't match? What about changes to the configuration
after the index has been created, e.g. new stop words or dictionaries?
That's possible intentional case, so we should not throw ERROR!
The two big open issues are whether we allow a default configuration,
and whether we require the configuration name to be always specified.
My guess right now is that we use a GUC that will default if a
pg_catalog configuration name matches the lc_ctype locale name, and we
have to throw an error if an accessed index creation GUC doesn't match
the current GUC.
Where will index store index creation GUC?
So we create a pg_catalog full text configuration named UTF8.en-US, and
some others like ru_RU.UTF-8.
Teodor Sigaev E-mail: [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not