🛑 Experiencing AccessExclusiveLock Stuck on Add Column with Default in Postgres
Hey folks, running into a weird issue on my Supabase postgres
ALTER TABLE abcd ADD COLUMN json_col_with_default jsonb DEFAULT '{}'::jsonb;
ALTER TABLE abcd ADD COLUMN json_col_with_default jsonb DEFAULT '{}'::jsonb;
- It acquires an AccessExclusiveLock but doesn’t complete. - No other queries seem to be blocking it. - Adding the column without a default works fine. - Dev DB works fine (even larger table).
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.