add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
3 rows affected
8 rows affected
1 rows affected
2 rows affected
config revision deployed status names
config_foo 1 t other.name, some.name
config_foo 2 t ACTIVE other.name, revised.name, third.name
config_bar 1 f other.name, some.name, unique.name
ERROR:  duplicate key value violates unique constraint "published_public_name_name_key"
DETAIL:  Key (name)=(other.name) already exists.
CONTEXT:  SQL statement "INSERT INTO published_public_name(config_id, name)
    SELECT NEW.id, pn.name
    FROM public_name pn
    WHERE pn.revision_id = NEW.current_revision_id
    ORDER BY pn.name"
PL/pgSQL function copy_published_public_names() line 23 at SQL statement

config revision deployed status names
config_foo 1 t other.name, some.name
config_foo 2 t ACTIVE other.name, revised.name, third.name
config_bar 1 f other.name, some.name, unique.name
1 rows affected
1 rows affected
1 rows affected
config revision deployed status names
config_foo 1 t other.name, some.name
config_foo 2 t other.name, revised.name, third.name
config_bar 1 t ACTIVE other.name, some.name, unique.name