© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
6 replies
felixthehat

RLS Insert working but Upsert throws a 'new row violates row-level security policy 42501' error

Hi folks, I can't work out the RLS rule to allow upserts, when insert is working fine, is there a rule I should be adding for upserting? thanks!
unknown.png
unknown.png
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

upsert() new row violates row-level security policy
SupabaseSSupabase / help-and-questions
4y ago
42501 - "New row violates row-level security for table"
SupabaseSSupabase / help-and-questions
3y ago
StorageApiError: new row violates row-level security policy
SupabaseSSupabase / help-and-questions
4mo ago
RLS policy set but message: "new row violates row-level security policy for table xxxxxx"
SupabaseSSupabase / help-and-questions
14mo ago