404 on public feedback post detail (PGRST200)
Shipped· by someone· 4 days ago
Visiting a post detail URL like /hollahoop/feedback/feature-requests/p/<id> returned 404. Real cause was a PGRST200 on the upstream PostgREST query because we tried to embed author:profiles on posts — but posts.author_id references auth.users, not public.profiles, so PostgREST couldn't infer the relationship.
Fixed by removing the embedded select and attaching author profiles via a second query in lib/data/feedback.ts.
Comments (0)
No comments yet.
Sign in to leave a comment.