Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseβ€’4y agoβ€’
7 replies
Lukas

cannot execute DELETE in a read-only transaction

Hi, I'm trying to delete an entry through a database function when the user calls this function, but I always get this error.

I already checked
select pg_is_in_recovery();
select pg_is_in_recovery();
and
show default_transaction_read_only;
show default_transaction_read_only;
.
I also tried to set
set transaction read write;
set transaction read write;
but then I'll get this error:
set transaction read write;
set transaction read write;
.

Please help
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

Read-only transaction error
SupabaseSSupabase / help-and-questions
4y ago
Ran - "ALTER DATABASE postgres SET default_transaction_read_only = on;"
SupabaseSSupabase / help-and-questions
3w ago
Connection times out in Transaction mode only
SupabaseSSupabase / help-and-questions
7d ago
Cannot Delete Row
SupabaseSSupabase / help-and-questions
4mo ago