Re: Full Text Indexing Patch - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Full Text Indexing Patch
Date
Msg-id 200108031617.f73GHd528393@candle.pha.pa.us
Whole thread Raw
In response to Full Text Indexing Patch  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

    http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

> 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Fuzzy matching
Next
From: Bruce Momjian
Date:
Subject: Re: Patch for Improved Syntax Error Reporting