summaryrefslogtreecommitdiff
path: root/contrib/fulltextindex
Commit message (Collapse)AuthorAgeFilesLines
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-291-1/+1
|
* pgindent run.Bruce Momjian2003-08-041-3/+3
|
* Error message editing in contrib (mostly by Joe Conway --- thanks Joe!)Tom Lane2003-07-241-13/+36
|
* Backend support for autocommit removed, per recent discussions. TheTom Lane2003-05-143-5/+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.
* This patch fixes a bunch of spelling mistakes in comments throughout theTom Lane2003-03-101-1/+1
| | | | | | PostgreSQL source code. Neil Conway
* This patch fixes an incorrect statement and makes a few cleanups toBruce Momjian2003-01-151-4/+3
| | | | | | | | contrib/fulltextindex/README.fti Backpatched to 7.3.X too. Neil Conway
* Update /contrib for "autocommit TO 'on'".Bruce Momjian2002-10-183-2/+12
| | | | | | | | | | Create objects in public schema. Make spacing/capitalization consistent. Remove transaction block use for object creation. Remove unneeded function GRANTs.
* This grants execute privileges to public for the fti() function. ShouldBruce Momjian2002-09-201-0/+2
| | | | | | we go through and give all the contribs grants? Christopher Kings-Lynne
* In case Florian and I don't finish his changes to this contrib beforeBruce Momjian2002-09-025-5/+31
| | | | | | | | beta, at least get this stuff in. ftipatch.txt - Updates to docs and scripts. Run in the fulltextindexdir WARNING - Add to fulltextindex dir uninstall.sql - Add to fulltextindex dir
* Code review for HeapTupleHeader changes. Add version number to page headersTom Lane2002-09-021-1/+1
| | | | | | | | | | (overlaying low byte of page size) and add HEAP_HASOID bit to t_infomask, per earlier discussion. Simplify scheme for overlaying fields in tuple header (no need for cmax to live in more than one place). Don't try to clear infomask status bits in tqual.c --- not safe to do it there. Don't try to force output table of a SELECT INTO to have OIDs, either. Get rid of unnecessarily complex three-state scheme for TupleDesc.tdhasoids, which has already caused one recent failure. Improve documentation.
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-224-4/+4
| | | | | | 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 ...
* oid is needed, it is added at the end of the struct (after the nullBruce Momjian2002-07-201-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bitmap, if present). Per Tom Lane's suggestion the information whether a tuple has an oid or not is carried in the tuple descriptor. For debugging reasons tdhasoid is of type char, not bool. There are predefined values for WITHOID, WITHOUTOID and UNDEFOID. This patch has been generated against a cvs snapshot from last week and I don't expect it to apply cleanly to current sources. While I post it here for public review, I'm working on a new version against a current snapshot. (There's been heavy activity recently; hope to catch up some day ...) This is a long patch; if it is too hard to swallow, I can provide it in smaller pieces: Part 1: Accessor macros Part 2: tdhasoid in TupDesc Part 3: Regression test Part 4: Parameter withoid to heap_addheader Part 5: Eliminate t_oid from HeapTupleHeader Part 2 is the most hairy part because of changes in the executor and even in the parser; the other parts are straightforward. Up to part 4 the patched postmaster stays binary compatible to databases created with an unpatched version. Part 5 is small (100 lines) and finally breaks compatibility. Manfred Koizar
* New pgindent run with fixes suggested by Tom. Patch manually reviewed,Bruce Momjian2001-11-051-3/+3
| | | | initdb/regression tests pass.
* pgindent run on all C files. Java run to follow. initdb/regressionBruce Momjian2001-10-251-57/+51
| | | | tests pass.
* Fix some portability problems (get it to compile, at least, on HP's cc)Tom Lane2001-10-151-4/+8
|
* To fix the perpetually broken makefiles in the contrib tree, I havePeter Eisentraut2001-09-061-37/+7
| | | | | | written a generic framework of rules that the contrib makefiles can use instead of writing their own each time. You only need to set a few variables and off you go.
* This patch adds the following to the FTI module:Bruce Momjian2001-08-043-142/+190
| | | | | | | | | | | | | | | | | | | | | | * 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
* The attached patch enables the contrib subtree to build cleanly underBruce Momjian2001-06-181-1/+2
| | | | | | | | | | | | | | | | | | | | | Cygwin with the possible exception of mSQL-interface. Since I don't have mSQL installed, I skipped this tool. Except for dealing with a missing getopt.h (oid2name) and HUGE (seg), the bulk of the patch uses the standard PostgreSQL approach to deal with Windows DLL issues. I tested the build aspect of this patch under Cygwin and Linux without any ill affects. Note that I did not actually attempt to test the code for functionality. The procedure to apply the patch is as follows: $ # save the attachment as /tmp/contrib.patch $ # change directory to the top of the PostgreSQL source tree $ patch -p0 </tmp/contrib.patch Jason
* pgindent run. Make it all clean.Bruce Momjian2001-03-221-4/+4
|
* Make sure -L and -I's for our source tree are always before system includePeter Eisentraut2001-02-201-2/+2
| | | | or library directories on the command line.
* Restructure the key include files per recent pghackers discussion: thereTom Lane2001-02-101-2/+3
| | | | | | | | | | | are now separate files "postgres.h" and "postgres_fe.h", which are meant to be the primary include files for backend .c files and frontend .c files respectively. By default, only include files meant for frontend use are installed into the installation include directory. There is a new make target 'make install-all-headers' that adds the whole content of the src/include tree to the installed fileset, for use by people who want to develop server-side code without keeping the complete source tree on hand. Cleaned up a whole lot of crufty and inconsistent header inclusions.
* Add fulltextindex TODO list.Bruce Momjian2000-12-091-0/+1
|
* Ensure that all uses of <ctype.h> functions are applied to unsigned-charTom Lane2000-12-031-8/+7
| | | | | values, whether the local char type is signed or not. This is necessary for portability. Per discussion on pghackers around 9/16/00.
* Revise handling of oldstyle/newstyle functions per recent discussionsTom Lane2000-11-204-4/+6
| | | | | | | | | 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 support for VPATH builds, that is, building somewhere else than in thePeter Eisentraut2000-10-201-2/+3
| | | | | | | | | source directory. This involves mostly makefiles using $(srcdir) when they might have used ".". (Regression tests don't work with this, yet.) Sort out usage of CPPFLAGS, CFLAGS (and CXXFLAGS). Add "override" keyword in most places, to preserve necessary flags even when the user overrode the flags.
* Another round of those unportable config/build changes :-/Peter Eisentraut2000-07-092-39/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Add option to build with OpenSSL out of the box. Fix thusly exposed bit rot. Although it compiles now, getting this to do something useful is left as an exercise. * Fix Kerberos options to defer checking for required libraries until all the other libraries are checked for. * Change default odbcinst.ini and krb5.srvtab path to PREFIX/etc. * Install work around for Autoconf's install-sh relative path anomaly. Get rid of old INSTL_*_OPTS variables, now that we don't need them anymore. * Use `gunzip -c' instead of g?zcat. Reportedly broke on AIX. * Look for only one of readline.h or readline/readline.h, not both. * Make check for PS_STRINGS cacheable. Don't test for the header files separately. * Disable fcntl(F_SETLK) test on Linux. * Substitute the standard GCC warnings set into CFLAGS in configure, don't add it on in Makefile.global. * Sweep through contrib tree to teach makefiles standard semantics. ... and in completely unrelated news: * Make postmaster.opts arbitrary options-aware. I still think we need to save the environment as well.
* Makefile cleanup from Karel.Bruce Momjian2000-07-041-2/+2
|
* Now that I look at it, is_stopword() is broken and always has been.Tom Lane2000-07-041-4/+3
| | | | Doesn't anyone remember how to program a binary search??
* Result of strcmp() is a signed int. Per bug reportTom Lane2000-07-041-1/+1
| | | | from Paul McGarry.
* Remove old README files.Bruce Momjian2000-06-191-0/+0
|
* Add missing /contrib filesBruce Momjian2000-06-191-0/+197
|
* Update to /contrib from Karel.Bruce Momjian2000-06-194-201/+4
|
* Cleanup README Makefile installs.Bruce Momjian2000-06-161-3/+3
|
* Add missing /contrib files to CVS.Bruce Momjian2000-06-152-0/+207
|
* /contrib patch from Karel.Bruce Momjian2000-06-154-317/+150
|
* Generated header files parse.h and fmgroids.h are now copied intoTom Lane2000-05-291-1/+1
| | | | | the src/include tree, so that -I backend is no longer necessary anywhere. Also, clean up some bit rot in contrib tree.
* Second round of fmgr changes: triggers are now invoked in new style,Tom Lane2000-05-293-26/+25
| | | | CurrentTriggerData is history.
* pgindent run over code.Bruce Momjian1999-05-251-119/+139
|
* Replace direct inclusions of c.h with inclusion of postgres.h,Tom Lane1999-01-171-1/+1
| | | | to ensure that config.h is included as well.
* New HeapTuple structure/interface.Vadim B. Mikheev1998-11-271-1/+1
|
* fulltext copy script.Bruce Momjian1998-08-221-0/+204
|
* Add contributor name to fulltextindex, and clean up contrib/README.Bruce Momjian1998-07-201-3/+1
|
* Update fti README and stopwords.Bruce Momjian1998-07-202-0/+8
|
* I finally got the time to put together some stuff for fti forBruce Momjian1998-07-195-0/+947
inclusion in pgsql. I have included a README which should be enough to start using it, plus a BENCH file that describes some timings I have done. Please have a look at it, and if you think everything is OK, I would like it seen included in the contrib-section of pgsql. I don't think I will do any more work in this, but maybe it inspires somebody else to improve on it. Maarten Boekhold