E11 Adding a SERIAL or GENERATED ... STORED column


Triggered when: A new column was added with a SERIAL or GENERATED type.

Effect: This blocks all table access until the table is rewritten.

Workaround: Can not be done without a table rewrite.

Detected by: eugene lint

Problematic migration

-- 1.sql
create table prices (
    price int not null

-- 2.sql
set local lock_timeout = '2s';
alter table prices
    add column id serial;

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