tsearch core path, v0.58

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: tsearch core path, v0.58
Date: 2007-07-23 17:12:29
Message-ID: 46A4E17D.3050109@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

http://www.sigaev.ru/misc/tsearch_core-0.58.gz

Changes since 0.52 version:

1) Introduce dictionary's template which contains only methods of dictionary and
can be managed only by superuser.
CREATE TEXT SEARCH DICTIONARY dictname
TEMPLATE dicttmplname
[OPTION opt_text ]
;

CREATE TEXT SEARCH DICTIONARY TEMPLATE dicttmplname
LEXIZE lexize_function
[INIT init_function ]
;

DROP TEXT SEARCH DICTIONARY TEMPLATE [IF EXISTS] dicttmplname [CASCADE]
ALTER TEXT SEARCH DICTIONARY TEMPLATE dicttmplname RENAME TO newname;

psql has \dFt command operated templates

2) parser and dictionary template could be managed only by superuser (due to
security reasons pointed by Tom). So, they don't have owner columns and removed
ALTER .. PARSER .. OWNER TO command

4) As Bruce suggests, GUC variable tsearch_conf_name is renamed to
default_text_search_config and trigger tsearch is renamed to tsvector_update_trigger

5) remove cfglocale and cfgdefault columns in configuration. So, CREATE/ALTER ..
CONFIGURATION hasn't AS DEFAULT and LOCALE options. Instead of that initdb tries
to find suitable configuration name for selected locale. Or it uses -T,
--text-search-config=CFG switch.

6) pg_dump, psql are changed accordingly.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-07-23 17:13:46 Re: [HACKERS] Oops in fe-auth.c
Previous Message Magnus Hagander 2007-07-23 16:59:19 Re: Oops in fe-auth.c