From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: Full Text Indexing Patch |
Date: | 2001-08-04 19:41:03 |
Message-ID: | 200108041941.f74Jf3217083@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Patch applied. Thanks.
> Hi,
>
> This patch adds the following to the FTI module:
>
> * The ability to index more than one column in a table with a single
> trigger.
> * All uses of sprintf changed to snprintf to prevent users from crashing
> Postgres.
> * Error messages made more consistent
> * Some changes made to bring it into line with coding requirements for
> triggers specified in the docs. (ie. check you're a trigger before casting
> your context)
> * The perl script that generate indices has been updated to support indexing
> multiple columns in a table.
> * Fairly well tested in our development environment indexing a food
> database's brand and description fields. The size of the fti index is
> around 300,000 rows.
> * All docs and examples upgraded. This includes specifying more efficient
> index usage that was specified before, better examples that don't produce
> duplicates, etc.
>
> This functionality makes fti greatly more useful!
>
> Chris & Brett
>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-08-04 19:42:53 | Re: [HACKERS] Small patch for Hurd |
Previous Message | Bruce Momjian | 2001-08-04 19:39:08 | Re: Revised Patch to allow multiple table locks in "Unison" |