← All errors · SupabaseSupabase database & RLS errors
Could not find the column in the schema cache
Exact error
Could not find the 'avatar_url' column of 'profiles' in the schema cache
What it means
The PostgREST API layer doesn't know about this column, either because it doesn't exist or the API's schema cache is stale. Error code PGRST204.
Likely causes
- Column name typo in your insert/update.
- Column added recently and the schema cache hasn't reloaded.
How to fix it
Confirm the column exists in Table Editor with exactly that name.
Reload the PostgREST schema cache from the SQL editor:
notify pgrst, 'reload schema';
Prevent this next time
- Keep schema and RLS policies in migrations (`supabase migration new`) instead of editing production by hand.
- Test each policy as both an anonymous and a signed-in user before shipping.
FAQ
What does "Could not find the column in the schema cache" mean?
The PostgREST API layer doesn't know about this column, either because it doesn't exist or the API's schema cache is stale. Error code PGRST204.
What usually causes it?
Column name typo in your insert/update. Column added recently and the schema cache hasn't reloaded.
How do I fix it?
1. Confirm the column exists in Table Editor with exactly that name. 2. Reload the PostgREST schema cache from the SQL editor:
Related errors
Get new fixes weekly
No spam. Unsubscribe anytime. Privacy