© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•5mo ago•
2 replies
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;
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 banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Postgres Upgrade stuck
SupabaseSSupabase / help-and-questions
5mo ago
Postgres upgrade is stuck
SupabaseSSupabase / help-and-questions
5mo ago
Dashboard stuck on `Connecting to Default Project`
SupabaseSSupabase / help-and-questions
4y ago
Default `USER postgres search_path`
SupabaseSSupabase / help-and-questions
4y ago