1.56.  dropset( integer )

Propriétés de la fonction
Langage: PLPGSQL
Type du code retour: bigint

Traite l'événement DROP_SET pour supprimer la réplication de l'ensemble set_id. Ceci implique de :

declare
        p_set_id                        alias for $1;
        v_origin                        int4;
begin
        -- ----
        -- Grab the central configuration lock
        -- ----
        lock table sl_config_lock;
        
        -- ----
        -- Check that the set exists and originates here
        -- ----
        select set_origin into v_origin from sl_set
                        where set_id = p_set_id;
        if not found then
                raise exception 'Slony-I: set % not found', p_set_id;
        end if;
        if v_origin != getLocalNodeId('_schemadoc') then
                raise exception 'Slony-I: set % does not originate on local node',
                                p_set_id;
        end if;

        -- ----
        -- Call the internal drop set functionality and generate the event
        -- ----
        perform dropSet_int(p_set_id);
        return  createEvent('_schemadoc', 'DROP_SET', 
                        p_set_id::text);
end;