Horton

Tsearch2 functionality migrates to core. The bulk of this work is by

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 140d4ebcb46e17cdb1be43892ed797e5e060c8ef
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2007-08-21T01:11:32Z
Releases: 8.3.0 
Tsearch2 functionality migrates to core.  The bulk of this work is by
Oleg Bartunov and Teodor Sigaev, but I did a lot of editorializing,
so anything that's broken is probably my fault.

Documentation is nonexistent as yet, but let's land the patch so we can
get some portability testing done.

Files

PathChange+/−
doc/src/sgml/datatype.sgml modified +26 −4
doc/src/sgml/func.sgml modified +6 −4
src/backend/access/gin/ginarrayproc.c modified +11 −2
src/backend/catalog/aclchk.c modified +72 −3
src/backend/catalog/dependency.c modified +138 −3
src/backend/catalog/Makefile modified +3 −1
src/backend/catalog/namespace.c modified +556 −1
src/backend/catalog/system_views.sql modified +72 −1
src/backend/commands/alter.c modified +25 −1
src/backend/commands/comment.c modified +79 −1
src/backend/commands/Makefile modified +3 −2
src/backend/commands/tablecmds.c modified +6 −1
src/backend/commands/tsearchcmds.c added +1948 −0
src/backend/Makefile modified +6 −3
src/backend/parser/gram.y modified +224 −9
src/backend/parser/keywords.c modified +7 −1
src/backend/parser/parse_coerce.c modified +6 −2
src/backend/snowball/dict_snowball.c added +326 −0
src/backend/snowball/libstemmer/api.c added +64 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_danish.c added +337 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_dutch.c added +624 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_english.c added +1117 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_finnish.c added +762 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_french.c added +1246 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_german.c added +503 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_hungarian.c added +1230 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_italian.c added +1065 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_norwegian.c added +297 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_porter.c added +749 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_portuguese.c added +1017 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_spanish.c added +1093 −0
src/backend/snowball/libstemmer/stem_ISO_8859_1_swedish.c added +307 −0
src/backend/snowball/libstemmer/stem_ISO_8859_2_romanian.c added +998 −0
src/backend/snowball/libstemmer/stem_KOI8_R_russian.c added +700 −0
src/backend/snowball/libstemmer/stem_UTF_8_danish.c added +339 −0
src/backend/snowball/libstemmer/stem_UTF_8_dutch.c added +634 −0
src/backend/snowball/libstemmer/stem_UTF_8_english.c added +1125 −0
src/backend/snowball/libstemmer/stem_UTF_8_finnish.c added +768 −0
src/backend/snowball/libstemmer/stem_UTF_8_french.c added +1256 −0
src/backend/snowball/libstemmer/stem_UTF_8_german.c added +509 −0
src/backend/snowball/libstemmer/stem_UTF_8_hungarian.c added +1234 −0
src/backend/snowball/libstemmer/stem_UTF_8_italian.c added +1073 −0
src/backend/snowball/libstemmer/stem_UTF_8_norwegian.c added +299 −0
src/backend/snowball/libstemmer/stem_UTF_8_porter.c added +755 −0
src/backend/snowball/libstemmer/stem_UTF_8_portuguese.c added +1023 −0
src/backend/snowball/libstemmer/stem_UTF_8_romanian.c added +1004 −0
src/backend/snowball/libstemmer/stem_UTF_8_russian.c added +694 −0
src/backend/snowball/libstemmer/stem_UTF_8_spanish.c added +1097 −0
src/backend/snowball/libstemmer/stem_UTF_8_swedish.c added +309 −0
src/backend/snowball/libstemmer/stem_UTF_8_turkish.c added +2205 −0
src/backend/snowball/libstemmer/utilities.c added +473 −0
src/backend/snowball/Makefile added +144 −0
src/backend/snowball/README added +47 −0
src/backend/snowball/snowball_func.sql.in added +18 −0
src/backend/snowball/snowball.sql.in added +26 −0
src/backend/snowball/stopwords/danish.stop added +94 −0
src/backend/snowball/stopwords/dutch.stop added +101 −0
src/backend/snowball/stopwords/english.stop added +128 −0
src/backend/snowball/stopwords/finnish.stop added +235 −0
src/backend/snowball/stopwords/french.stop added +155 −0
src/backend/snowball/stopwords/german.stop added +231 −0
src/backend/snowball/stopwords/hungarian.stop added +199 −0
src/backend/snowball/stopwords/italian.stop added +279 −0
src/backend/snowball/stopwords/norwegian.stop added +176 −0
src/backend/snowball/stopwords/portuguese.stop added +203 −0
src/backend/snowball/stopwords/russian.stop added +151 −0
src/backend/snowball/stopwords/spanish.stop added +313 −0
src/backend/snowball/stopwords/swedish.stop added +114 −0
src/backend/tcop/utility.c modified +117 −1
src/backend/tsearch/dict.c added +131 −0
src/backend/tsearch/dict_ispell.c added +164 −0
src/backend/tsearch/dict_simple.c added +65 −0
src/backend/tsearch/dict_synonym.c added +176 −0
src/backend/tsearch/dict_thesaurus.c added +887 −0
src/backend/tsearch/Makefile added +51 −0
src/backend/tsearch/regis.c added +236 −0
src/backend/tsearch/spell.c added +1747 −0
src/backend/tsearch/synonym.syn.sample added +3 −0
src/backend/tsearch/thesaurus.ths.sample added +20 −0
src/backend/tsearch/to_tsany.c added +363 −0
src/backend/tsearch/ts_locale.c added +241 −0
src/backend/tsearch/ts_parse.c added +626 −0
src/backend/tsearch/ts_utils.c added +330 −0
src/backend/tsearch/wparser.c added +360 −0
src/backend/tsearch/wparser_def.c added +1873 −0
src/backend/utils/adt/Makefile modified +6 −3
src/backend/utils/adt/regproc.c modified +228 −1
src/backend/utils/adt/selfuncs.c modified +5 −1
src/backend/utils/adt/tsginidx.c added +157 −0
src/backend/utils/adt/tsgistidx.c added +784 −0
src/backend/utils/adt/tsquery.c added +767 −0
src/backend/utils/adt/tsquery_cleanup.c added +261 −0
src/backend/utils/adt/tsquery_gist.c added +259 −0
src/backend/utils/adt/tsquery_op.c added +289 −0
src/backend/utils/adt/tsquery_rewrite.c added +524 −0
src/backend/utils/adt/tsquery_util.c added +317 −0
src/backend/utils/adt/tsrank.c added +804 −0
src/backend/utils/adt/tsvector.c added +683 −0
src/backend/utils/adt/tsvector_op.c added +1334 −0
src/backend/utils/cache/catcache.c modified +3 −1
src/backend/utils/cache/Makefile modified +2 −2
src/backend/utils/cache/syscache.c modified +114 −1
src/backend/utils/cache/ts_cache.c added +641 −0
src/backend/utils/misc/guc.c modified +14 −4
src/backend/utils/misc/postgresql.conf.sample modified +3 −0
src/bin/initdb/initdb.c modified +185 −3
src/bin/pg_dump/common.c modified +25 −1
src/bin/pg_dump/pg_backup_archiver.c modified +7 −3
src/bin/pg_dump/pg_dump.c modified +721 −1
src/bin/pg_dump/pg_dump.h modified +40 −1
src/bin/pg_dump/pg_dump_sort.c modified +29 −1
src/bin/psql/command.c modified +22 −1
src/bin/psql/describe.c modified +518 −2
src/bin/psql/describe.h modified +13 −1
src/bin/psql/help.c modified +5 −1
src/include/access/gin.h modified +4 −2
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/dependency.h modified +9 −1
src/include/catalog/indexing.h modified +24 −1
src/include/catalog/namespace.h modified +14 −2
src/include/catalog/pg_aggregate.h modified +4 −1
src/include/catalog/pg_amop.h modified +36 −1
src/include/catalog/pg_amproc.h modified +50 −29
src/include/catalog/pg_cast.h modified +15 −1
src/include/catalog/pg_opclass.h modified +6 −1
src/include/catalog/pg_operator.h modified +29 −1
src/include/catalog/pg_opfamily.h modified +7 −3
src/include/catalog/pg_proc.h modified +263 −1
src/include/catalog/pg_ts_config.h added +65 −0
src/include/catalog/pg_ts_config_map.h added +83 −0
src/include/catalog/pg_ts_dict.h added +68 −0
src/include/catalog/pg_ts_parser.h added +72 −0
src/include/catalog/pg_ts_template.h added +72 −0
src/include/catalog/pg_type.h modified +24 −1
src/include/commands/defrem.h modified +30 −1
src/include/nodes/nodes.h modified +3 −1
src/include/nodes/parsenodes.h modified +36 −1
src/include/snowball/header.h added +62 −0
src/include/snowball/libstemmer/api.h added +26 −0
src/include/snowball/libstemmer/header.h added +58 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_danish.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_dutch.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_english.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_finnish.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_french.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_german.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_hungarian.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_italian.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_norwegian.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_porter.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_portuguese.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_spanish.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_1_swedish.h added +16 −0
src/include/snowball/libstemmer/stem_ISO_8859_2_romanian.h added +16 −0
src/include/snowball/libstemmer/stem_KOI8_R_russian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_danish.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_dutch.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_english.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_finnish.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_french.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_german.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_hungarian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_italian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_norwegian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_porter.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_portuguese.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_romanian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_russian.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_spanish.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_swedish.h added +16 −0
src/include/snowball/libstemmer/stem_UTF_8_turkish.h added +16 −0
src/include/tsearch/dicts/regis.h added +49 −0
src/include/tsearch/dicts/spell.h added +153 −0
src/include/tsearch/ts_cache.h added +98 −0
src/include/tsearch/ts_locale.h added +88 −0
src/include/tsearch/ts_public.h added +128 −0
src/include/tsearch/ts_type.h added +240 −0
src/include/tsearch/ts_utils.h added +315 −0
src/include/utils/acl.h modified +5 −1
src/include/utils/builtins.h modified +9 −1
src/include/utils/syscache.h modified +12 −3
src/Makefile modified +4 −1
src/makefiles/Makefile.hpux modified +2 −2
src/test/regress/data/tsearch.data added +508 −0
src/test/regress/expected/create_table.out modified +4 −0
src/test/regress/expected/oidjoins.out modified +136 −0
src/test/regress/expected/opr_sanity.out modified +4 −1
src/test/regress/expected/sanity_check.out modified +7 −1
src/test/regress/expected/tsearch.out added +893 −0
src/test/regress/expected/tstypes.out added +495 −0
src/test/regress/input/copy.source modified +2 −0
src/test/regress/output/copy.source modified +1 −0
src/test/regress/output/misc.source modified +2 −1
src/test/regress/parallel_schedule modified +21 −13
src/test/regress/serial_schedule modified +5 −3
src/test/regress/sql/create_table.sql modified +6 −0
src/test/regress/sql/oidjoins.sql modified +68 −0
src/test/regress/sql/tsearch.sql added +292 −0
src/test/regress/sql/tstypes.sql added +95 −0
src/tools/findoidjoins/findoidjoins.c modified +4 −2