NAME¶

DROP LISTEN - Eliminate configuration indicating how Slony-I node listens for events

SYNOPSIS¶

DROP LISTEN (options);

DESCRIPTION¶

Remove a ‘listen’ configuration entry.

ORIGIN = ival

Node ID of the event origin the receiver is listening for.

PROVIDER = ival

Node ID of the node from which the receiver gets events that come from the origin. If not specified, default is the origin.

RECEIVER = ival

The ID of the node receiving the events.

This uses “schemadocdroplisten(p_li_receiver integer, p_li_provider integer, p_li_origin integer)” [not available as a man page].

EXAMPLE¶

     DROP LISTEN ( ORIGIN = 1, RECEIVER = 2, PROVIDER = 3 );


    

LOCKING BEHAVIOUR ¶

No application-visible locking should take place.

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. As of version 1.1, you should not need to use it anymore.