Version:

spock.repset_add_all_seqs()

NAME

SYNOPSIS

spock.repset_add_all_seqs (set_name name, schema_names text[], synchronize_data boolean)

RETURNS

true if all sequences were successfully added to the replication set.
ERROR if the call has invalid parameters, insufficient privileges, or the operation fails.

DESCRIPTION

Adds all existing sequences from the specified schemas to a replication set.

This function registers all sequence objects found in the given schemas with the specified replication set. Only sequences that exist at the time of execution are added; sequences created afterward must be added separately using spock.repset_add_seq().

The synchronize_data parameter controls whether sequence values are immediately synchronized across nodes. When set to true, the current value of each sequence is propagated to subscribers.

This function writes metadata into the Spock catalogs to track which sequences are part of the replication set.

This command must be executed by a superuser.

Warning: If you're deploying a multi-master replication scenario, we recommend that you not add sequences to a replication set. Instead, use Snowflake Sequences to manage sequences in a distributed environment and avoid conflicts.

ARGUMENTS

set_name

The name of an existing replication set.

schema_names

An array of schema names from which all sequences will be added.

synchronize_data

If true, synchronize the current value of each sequence immediately.
Default is false.

EXAMPLE

You can specify one or more schemas in the call to repset_add_all_seqs. The first command adds the sequences in the 'public' schema to the 'default' replication set:

postgres=# SELECT spock.repset_add_all_seqs('default', ARRAY['public']);
-[ RECORD 1 ]-------+--
repset_add_all_seqs | t

The following command adds all sequences in the schemas named 'public' and 'alice' to the 'default' replication set:

postgres=# SELECT spock.repset_add_all_seqs('default', ARRAY['public', 'alice'],true);
-[ RECORD 1 ]-------+--
repset_add_all_seqs | t