From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
Cc: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: default_text_search_config and expression indexes |
Date: | 2007-08-14 20:35:50 |
Message-ID: | 200708142035.l7EKZog06133@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-hackers |
Heikki Linnakangas wrote:
> Bruce Momjian wrote:
> > Heikki Linnakangas wrote:
> >> Bruce Momjian wrote:
> >>> Heikki Linnakangas wrote:
> >>>> Removing the default configuration setting altogether removes the 2nd
> >>>> problem, but that's not good from a usability point of view. And it
> >>>> doesn't solve the general issue, you can still do things like:
> >>>> SELECT * FROM foo WHERE to_tsvector('confA', textcol) @@
> >>>> to_tsquery('confB', 'query');
> >>> True, but in that case you are specifically naming different
> >>> configurations, so it is hopefully obvious you have a mismatch.
> >> There's many more subtle ways to do that. For example, filling a
> >> tsvector column using a DEFAULT clause. But then you sometimes fill it
> >> in the application instead, with a different configuration. Or if one of
> >> the function calls is buried in another user defined function.
> >>
> >> I don't think explicitly naming the configuration gives enough protection.
> >
> > Oh, wow, OK, well in that case the text search API isn't ready and we
> > will have to hold this for 8.4.
>
> That would be unfortunate :(. Sorry I haven't looked at this earlier. Do
> you think that implementing a strongly typed system is too much work for
> 8.3?
Yea, probably. See my other posting with an updated subject line.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-08-14 20:38:51 | Re: default_text_search_config and expression indexes |
Previous Message | Mike Rylander | 2007-08-14 20:35:14 | Re: default_text_search_config and expression indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-14 20:37:29 | Re: change name of redirect_stderr? |
Previous Message | Mike Rylander | 2007-08-14 20:35:14 | Re: default_text_search_config and expression indexes |