Version:

spock.repset_remove_seq()

NAME

spock.repset_remove_seq ()

spock.repset_remove_seq ( set_name name, relation regclass)

- true if the sequence was successfully removed from the replication set.
- false if the sequence was not a member of the replication set.

Removes a sequence from an existing Spock replication set.

After removal, changes to the sequence value are no longer replicated to subscribers of the replication set.

This function updates metadata stored in the Spock catalogs and does not modify PostgreSQL configuration.

This command must be executed by a superuser.

set_name

The name of an existing replication set.

relation

The sequence to remove, specified as a regclass
(for example, 'public.my_sequence').

Remove a sequence (public.orders_id_seq) from a replication set (demo_repset):

postgres=# SELECT spock.repset_remove_seq('demo_repset', 'public.orders_id_seq');
 repset_remove_seq 
-------------------
 t
(1 row)