Full Text Indexing Patch

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Full Text Indexing Patch
Date: 2001-08-03 08:04:47
Message-ID: ECEHIKNFIMMECLEBJFIGOEHLCBAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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 Content-Type Size
fti.diff application/octet-stream 23.1 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Hiroshi Inoue 2001-08-03 08:43:10 Re: ODBC Boolean handling
Previous Message Tom Lane 2001-08-03 02:55:50 Schedule (was Re: [PATCHES] Patch for Improved Syntax Error Reporting)