E8 Creating a new exclusion constraint


Triggered when: Found a new exclusion constraint.

Effect: This blocks all reads and writes to the table while the constraint index is being created.

Workaround: There is no safe way to add an exclusion constraint to an existing table.

Detected by: eugene lint and eugene trace

Problematic migration

-- 1.sql
create table authors (
    id integer generated always as identity
        primary key,
    name text not null

-- 2.sql
set local lock_timeout = '2s';
alter table authors
    add constraint authors_name_excl
        exclude (name with =);

Safer migration

Currently, we don't know of a safe way to avoid this issue.

Report an issue at the tracker if you know a way!

Eugene report examples