Troubleshooting guides by topic
Supabase and databases
PostgreSQL, RLS, authentication, storage and database permissions.
77 English guides in this category
Supabase: SQL view shows other people's data despite RLS enabled
The query directly to the table respects RLS policies, but the SQL view API returns other people's lines to the user.
Read the solutionSupabase: too many clients already connected to PostgreSQL
The application periodically stops connecting to the database and logs in too many clients already.
Read the solutionSupabase: UPDATE ends without error, but does not change anything
Calling update().eq() returns an empty result, although the record exists in the database.
Read the solutionSupabase/PostgreSQL: Foreign Key Constraint Blocks User Deletion
Description of the diagnosis and repair procedure when an attempt to remove the user ends with a reference error: how to find dependent tables, check constraints, RLS policies and triggers, and safely remove or migrate the data.
Read the solutionWhy Supabase Returns a Maximum of 1,000 Rows
Analysis of the reasons for receiving up to 1000 records in the Supabase/PostgREST response. Includes differentiation of causes (customer, server, Range/LIMIT headers, middleware), specific test steps and ways to repair pagination.
Read the solution