From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru> |
Subject: | Re: text search vs schemas |
Date: | 2007-08-17 08:26:40 |
Message-ID: | 200708171026.41989.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Am Freitag, 17. August 2007 05:15 schrieb Tom Lane:
> Actually ... I'm suddenly not happy about the choice to put text search
> configurations etc. into schemas at all. We've been sitting here and
> assuming that to_tsvector('english', my_text_col) has a well defined
> meaning --- but as the patch stands, *it does not*. The interpretation
> of the config name could easily change depending on search_path.
But that isn't different from any other part of the system. A proper fix
would be a mechanism to alleviate the confusion in all places, not simply to
remove features that cause such confusion in some places (but not all,
thereby causing inconsistencies).
> It does not seem likely that a typical installation will have so many
> text search configs that subdividing them into schemas will really be
> useful.
But schemas are not only used to organize objects because there are so many.
Altering the search path to get at a different implementation without having
to alter the names in every single place is also a useful application.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2007-08-17 10:02:23 | Re: GIT patch |
Previous Message | Magnus Hagander | 2007-08-17 06:40:11 | Re: [HACKERS] Re: cvsweb busted (was Re: pgsql: Repair problems occurring when multiple RI updates have to be) |