SupabaseS
Supabase•3mo ago
abu_beegaran

🛑 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;

  • 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).
Was this page helpful?