Thread: Full Text Indexing Patch
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
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
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