Документ взят из кэша поисковой машины. Адрес оригинального документа : http://www.sai.msu.su/~megera/postgres/fts/doc/sql-fts-altercfg.html
Дата изменения: Unknown
Дата индексирования: Sun Apr 13 07:51:27 2008
Кодировка:
Поисковые слова: п п п п п п п п п п п
ALTER FULLTEXT CONFIGURATION
Full-Text Search in PostgreSQL: A Gentle Introduction
PrevFast BackwardFast ForwardNext

ALTER FULLTEXT CONFIGURATION

Name

ALTER FULLTEXT CONFIGURATION -- change a full-text configuration

Synopsis

ALTER FULLTEXT CONFIGURATION cfgname RENAME TO newcfgname;
ALTER FULLTEXT CONFIGURATION cfgname SET { LOCALE localename | PARSER prsname } [, ...];
ALTER FULLTEXT CONFIGURATION cfgname { SET AS | DROP } DEFAULT;

Description

ALTER FULLTEXT CONFIGURATION changes an existing full-text configuration.

Parameters

cfgname

The name (optionally schema-qualified) of the configuration to rename.

RENAME TO

newcfgname is the new name of the configuration. Notice, that schema cannot be changed.

SET

Values of LOCALE, PARSER parameters, if defined, will substitute current values.

SET AS DEFAULT

Set default flag for the configuration.

DROP DEFAULT

Remove default flag for the configuration.

Examples

There are could be maximum one configuration with DEFAULT flag defined in the same schema and with the same locale. 

=# \dF public.test*        
	   List of fulltext configurations
 Schema | Name  |   Locale    | Default | Description
--------+-------+-------------+---------+-------------
 public | test  | ru_RU.UTF-8 |         |
 public | test2 | ru_RU.UTF-8 | Y       |
=# ALTER FULLTEXT CONFIGURATION test2 DROP DEFAULT;
ALTER FULLTEXT CONFIGURATION
=# \dF public.test*
           List of fulltext configurations
 Schema | Name  |   Locale    | Default | Description
--------+-------+-------------+---------+-------------
 public | test  | ru_RU.UTF-8 |         |
 public | test2 | ru_RU.UTF-8 |         |
=# ALTER FULLTEXT CONFIGURATION test2 SET AS DEFAULT;
ALTER FULLTEXT CONFIGURATION
Time: 1.629 ms
postgres=# \dF public.test*
           List of fulltext configurations
 Schema | Name  |   Locale    | Default | Description
--------+-------+-------------+---------+-------------
 public | test  | ru_RU.UTF-8 |         |
 public | test2 | ru_RU.UTF-8 | Y       |

See Also

CREATE FULLTEXT CONFIGURATION
PrevHomeNext
DROP FULLTEXT CONFIGURATIONUpCREATE FULLTEXT DICTIONARY