Object Tagging: Tag Assignment Not Allowed When Creating Secondary Databases

Attention

This behavior change is in the 2023_04 bundle.

For the current status of the bundle, refer to Bundle History.

In the current release, you are not allowed to set tags on a secondary database using the WITH TAG clause when you create or replace a database using the AS REPLICA OF clause.

Previously:

You could specify the WITH TAG clause when you create a secondary database using the AS REPLICA OF clause. For example:

CREATE DATABASE <name> AS REPLICA OF <primary_database_name>
    WITH TAG (tag_name = 'tag_value');
Copy
Currently:

Specifying the WITH TAG clause when creating a secondary database using the AS REPLICA OF clause generates the following error message:

SQL compilation error: Tags cannot be assigned to a secondary database replica since it is a read-only database.

Please update existing workflows to remove the WITH TAG clause when creating secondary databases.

Ref: 961

Language: English