Документ взят из кэша поисковой машины. Адрес
оригинального документа
: http://www.sai.msu.su/~megera/postgres/fts/doc/sql-fts-alterowner.html
Дата изменения: Unknown Дата индексирования: Sun Apr 13 07:53:20 2008 Кодировка: Поисковые слова: aldebaran |
Full-Text Search in PostgreSQL: A Gentle Introduction | ||||
---|---|---|---|---|
Prev | Fast Backward | Fast Forward | Next |
The name (optionally schema-qualified) of the full-text object.
The new owner of the full-text object.
In this example we want to create new dictionary in schema test using predefined dictionary from system catalog. Then we change owner of the new dictionary. To demonstrate visibility rule we use the name of the dictionary without schema but setting the proper search_path. The name of the new dictionary is the same by intent.
=# CREATE SCHEMA test; =# CREATE FULLTEXT DICTIONARY test.synonym LIKE pg_catalog."synonym"; =# SHOW search_path; search_path ---------------- "$user",public =# SET search_path TO test,public; =# ALTER FULLTEXT DICTIONARY synonym OWNER TO megera;