Re: default_text_search_config and expression indexes

From: tomas(at)tuxteam(dot)de
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, 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-09 09:36:40
Message-ID: 20070809093640.GA21683@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Aug 09, 2007 at 02:36:41AM -0400, Bruce Momjian wrote:
> Oleg Bartunov wrote:
> > > Yea, seems more work than is necessary. If we require the configuration
> > > to be always supplied, and document that mismatches are a problem, I
> > > think we are in good shape.
> >
> > We should agree that all you describe is only for DUMMY users.
> > >From authors point of view I dislike your approach to treat text searching
> > as a very limited tool [...]

[...]

> I am glad we are moving this interface discussion forward. It seems
> Heikki has similar concerns about the interface being error-prone.
>
> It would be nice to have a novice and advanced interface, but we would
> have to document both, and then that is going to be confusing for users.
>
> As I see it, specifying the configuration name in every function call is
> the novice interface, and avoids the most common errors. I can see
> defaulting the interface name as being an advanced interface, but I
> don't think it has enough of a feature to be worth documenting and
> implementing.
>
> If we figure out something better in 8.4 we can implement it, but at
> this point I can't think of any good solution to not specifying the
> configuration name every time.

Maybe I'm missing something, but it seems to me that the configuration
is more attached to a column/index thatn to the whole database. If
there's a default in an expression, I'd rather expect this default to be
drawn from the index involved than from a global value (like a functional
index does now).

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGuuAoBcgs9XrR2kYRAqiiAJsFL+Iu/b/xYaLza5ozmi839Qh5awCeOp+f
SZHKDPUHZ3u99XzLBn2ZKjw=
=twEt
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Oleg Bartunov 2007-08-09 10:03:13 Re: default_text_search_config and expression indexes
Previous Message Peter Eisentraut 2007-08-09 08:30:12 Re: EnterpriseDB Postgres

Browse pgsql-hackers by date

  From Date Subject
Next Message Omar Bettin 2007-08-09 09:49:30 Re: comunication protocol
Previous Message Pavan Deolasee 2007-08-09 07:48:10 Re: HOT patch, missing things