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

FreeBSD Manual Pages

  
 
  

home | help
SLONIK SET DROP	TABLE(7Configuration and Action	commanSLONIK SET DROP TABLE(7)

NAME
       SET DROP	TABLE -	Remove a table from a	 Slony-I replication set

SYNOPSIS
       SET DROP	TABLE (options);

DESCRIPTION
       Drop a table from a replication set.

	ORIGIN = ival
	      Origin  node for the set.	 A future version of slonik might fig-
	      ure out this information by itself.

	ID = ival
	      Unique ID	of the table.

       This uses  setdroptable(integer)	.

EXAMPLE
	    SET	DROP TABLE (
	    ORIGIN = 1,
	    ID = 20
	    );

LOCKING	BEHAVIOUR
       This operation must acquire  an	exclusive  lock	 on  the  table	 being
       dropped	from  replication in order to alter it to drop the replication
       trigger.	 On subscriber nodes,  this  also  involves  adding  back  any
       rules/triggers that have	been hidden.

SLONIK EVENT CONFIRMATION BEHAVIOUR
       Slonik waits for	the command submitted to the previous event node to be
       confirmed on the	specified event	node before submitting this command.

VERSION	INFORMATION
       This command was	introduced in Slony-I 1.0.5

				  30 May 2016	      SLONIK SET DROP TABLE(7)

NAME | SYNOPSIS | DESCRIPTION | EXAMPLE | LOCKING BEHAVIOUR | SLONIK EVENT CONFIRMATION BEHAVIOUR | VERSION INFORMATION

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

home | help