Name

REPL_PUB_REMOVE — remove item from publication.

Synopsis

REPL_PUB_REMOVE ( in publication varchar ,
in item varchar ,
in type integer ,
in flag integer );

Description

This function is used to remove an item from existing publication. It's action is performed on publisher side and depending of flag it can send replication message to subscribers to remove this from subscription.

Parameters

publication

publication account name.

item

dependent on type should be:

Valid WebDAV collection full path in local repository.
Fully qualified table name.
Fully qualified Virtuoso/PL procedure name.

type

type of item, can accept following types:

1 - item is a WebDAV collection.
2 - item is a database table.
3 - item is a Virtuoso/PL procedure.

flag

Behavior on the subscriber side

NULL - do not send a replication message to the subscribers.
1 - send a message to the subscribers to remove entry from local description.

Example

Example24.326.Removal of an item from publication

This will remove the table Demo.demo.Products from publication. Furthermore issuing of the replication messages for this item will be stopped and subscriber will remove this entry from local description.

SQL> DB.DBA.REPL_PUB_REMOVE ('demo-publication', 'Demo.demo.Products', 2, 1);