-2

Im having an issue with supabase postgres changes. I have a subscription on frontend to watch for changes on a table using RLS policy to only see the changes of the current user.

The problem that im facing is that i can access the data with normal REST querys like supabase.from().select(*) but when subscribing like: supabase.channel.on i dont get any events at all. If i disable RLS or set a policy to allow read to everyone, i get the events but for every user, and i want to have only for the current user.

Improve this question
1
  • You'd have to put enough code into the question to allow somebody to reproduce the problem. Otherwise, you cannot expect an answer. Logical replication typically connects with a user that is exempt from row-level security. Commented 2 days ago
Related questions
1251
Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
0
Supabase and Stripe Customer ID with RLS
1
How do I use Supabase Realtime database with RLS and a custom JWT?
Load 3 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.