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 figure out this
              information by itself.

       ID = ival
              Unique ID of the table.

       This uses “schemadocsetdroptable(p_tab_id integer)” [not available as a man page].

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

                                         6 February 2014                 SLONIK SET DROP TABLE(7)