Re: Full Text Indexing Patch

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@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