summaryrefslogtreecommitdiff
path: root/contrib/fulltextindex/fti.pl
Commit message (Collapse)AuthorAgeFilesLines
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-141-1/+0
| | | | | | only remnant of this failed experiment is that the server will take SET AUTOCOMMIT TO ON. Still TODO: provide some client-side autocommit logic in libpq.
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-181-0/+2
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-221-1/+1
| | | | | | with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
* This patch adds the following to the FTI module:Bruce Momjian2001-08-041-3/+7
| | | | | | | | | | | | | | | | | | | | | | * 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. Christopher Kings-Lynne & Brett
* The fti.pl supplied with the fulltextindex module generate ALL possibleBruce Momjian2001-08-011-12/+13
| | | | | | | | | | | | | | | substrings of two characters or greater, and is case-sensitive. This patch makes it work correctly. It generates only the suffixes of each word, plus lowercases them - as specified by the README file. This brings it into line with the fti.c function, makes it case-insensitive properly, removes the problem with duplicate rows being returned from an fti search and greatly reduces the size of the generated index table. It was written by my co-worker, Brett Toolin. Christopher Kings-Lynne
* Revise handling of oldstyle/newstyle functions per recent discussionsTom Lane2000-11-201-1/+1
| | | | | | | | | in pghackers list. Support for oldstyle internal functions is gone (no longer needed, since conversion is complete) and pg_language entry 'internal' now implies newstyle call convention. pg_language entry 'newC' is gone; both old and newstyle dynamically loaded C functions are now called language 'C'. A newstyle function must be identified by an associated info routine. See src/backend/utils/fmgr/README.
* Add missing /contrib files to CVS.Bruce Momjian2000-06-151-0/+204