Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DROP TEXT SEARCH CONFIGUPostgreSQL 9.6.3 DocuDROPaTEXT SEARCH CONFIGURATION(7)

NAME
       DROP_TEXT_SEARCH_CONFIGURATION -	remove a text search configuration

SYNOPSIS
       DROP TEXT SEARCH	CONFIGURATION [	IF EXISTS ] name [ CASCADE | RESTRICT ]

DESCRIPTION
       DROP TEXT SEARCH	CONFIGURATION drops an existing	text search
       configuration. To execute this command you must be the owner of the
       configuration.

PARAMETERS
       IF EXISTS
	   Do not throw	an error if the	text search configuration does not
	   exist. A notice is issued in	this case.

       name
	   The name (optionally	schema-qualified) of an	existing text search
	   configuration.

       CASCADE
	   Automatically drop objects that depend on the text search
	   configuration, and in turn all objects that depend on those objects
	   (see	Section	5.13, "Dependency Tracking", in	the documentation).

       RESTRICT
	   Refuse to drop the text search configuration	if any objects depend
	   on it. This is the default.

EXAMPLES
       Remove the text search configuration my_english:

	   DROP	TEXT SEARCH CONFIGURATION my_english;

       This command will not succeed if	there are any existing indexes that
       reference the configuration in to_tsvector calls. Add CASCADE to	drop
       such indexes along with the text	search configuration.

COMPATIBILITY
       There is	no DROP	TEXT SEARCH CONFIGURATION statement in the SQL
       standard.

SEE ALSO
       ALTER TEXT SEARCH CONFIGURATION (ALTER_TEXT_SEARCH_CONFIGURATION(7)),
       CREATE TEXT SEARCH CONFIGURATION	(CREATE_TEXT_SEARCH_CONFIGURATION(7))

PostgreSQL 9.6.3		     2017    DROP TEXT SEARCH CONFIGURATION(7)

NAME | SYNOPSIS | DESCRIPTION | PARAMETERS | EXAMPLES | COMPATIBILITY | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DROP_TEXT_SEARCH_CONFIGURATION&sektion=7&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help