docs: add Supabase RLS recursion troubleshooting note
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 5
- Forks
- 7
- Avg merge
- 39m
- Merged PRs (30d)
- 39
Description
🎯 What needs to be done
Add a troubleshooting note in docs/TROUBLESHOOTING.md under database / Supabase configuration explaining how to resolve PostgreSQL error 42P17 (infinite recursion detected in policy for relation).
Why this matters
Contributors writing new Row-Level Security (RLS) policies may accidentally query the same table inside a subquery. Documenting the fix (SECURITY DEFINER functions or direct column lookups) prevents confusion and onboarding friction.
📍 Where to work
docs/TROUBLESHOOTING.md
🧭 Implementation guidance
- Open
docs/TROUBLESHOOTING.md. - Locate the database or Supabase troubleshooting section (or create subsection
3.3 Supabase RLS Policy Infinite Recursion (42P17)). - Add a concise problem explanation, cause, and recommended solution.
- Save the file.
✅ Acceptance criteria
-
docs/TROUBLESHOOTING.mddocuments PostgreSQL error 42P17 and its resolution clearly. - Markdown link validation passes with 0 broken links.
🧪 Verification
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Open docs/TROUBLESHOOTING.md and locate the database or Supabase configuration troubleshooting section. Add a concise explanation of PostgreSQL error 42P17, its RLS recursion cause, and the recommended SECURITY DEFINER or direct-column-lookup resolution. Verify that Markdown link validation passes with 0 broken links.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Active
- Clarity
- Clearly specified
- Newbie friendliness
- 90/100