Realtime not working with RLS

Hello! I am trying to listen for changes in realtime on a table called

folders

folders

, on which I have a few simple policies:

create policy "Users can create folders" on folders
  for insert with check (auth.uid() = user_id);

create policy "Users can view their own folders" on folders
  for select using (auth.uid() = user_id);

create policy "Users can update their own folders" on folders
  for update using (auth.uid() = user_id);

create policy "Users can delete their own folders" on folders
  for delete using (auth.uid() = user_id);

create policy "Users can create folders" on folders
  for insert with check (auth.uid() = user_id);

create policy "Users can view their own folders" on folders
  for select using (auth.uid() = user_id);

create policy "Users can update their own folders" on folders
  for update using (auth.uid() = user_id);

create policy "Users can delete their own folders" on folders
  for delete using (auth.uid() = user_id);

So I created a subscription like so:

const subscription = client.from("folders").on("*", (payload) => {
  console.log(payload)
}).subscribe()

const subscription = client.from("folders").on("*", (payload) => {
  console.log(payload)
}).subscribe()

The websocket connection is created successfully, however when I

INSERT

INSERT

UPDATE

UPDATE

some folders, it wasn't receiving any message (except a few times, randomly, I didn't figure out why). Yet, it was receiving the

DELETE

DELETE

messages.
So I disabled RLS on

folders

folders

table, and now it was working perfectly.

Project ID: hgqnfohuvgxsdcoymawt

I really don't have any idea on how to fix this, so I would really appreciate your help!

Realtime not working with RLS

Hello! I am trying to listen for changes in realtime on a table called

folders

folders

, on which I have a few simple policies:

create policy "Users can create folders" on folders
  for insert with check (auth.uid() = user_id);

create policy "Users can view their own folders" on folders
  for select using (auth.uid() = user_id);

create policy "Users can update their own folders" on folders
  for update using (auth.uid() = user_id);

create policy "Users can delete their own folders" on folders
  for delete using (auth.uid() = user_id);

create policy "Users can create folders" on folders
  for insert with check (auth.uid() = user_id);

create policy "Users can view their own folders" on folders
  for select using (auth.uid() = user_id);

create policy "Users can update their own folders" on folders
  for update using (auth.uid() = user_id);

create policy "Users can delete their own folders" on folders
  for delete using (auth.uid() = user_id);

So I created a subscription like so:

const subscription = client.from("folders").on("*", (payload) => {
  console.log(payload)
}).subscribe()

const subscription = client.from("folders").on("*", (payload) => {
  console.log(payload)
}).subscribe()

The websocket connection is created successfully, however when I

INSERT

INSERT

UPDATE

UPDATE

some folders, it wasn't receiving any message (except a few times, randomly, I didn't figure out why). Yet, it was receiving the

DELETE

DELETE

messages.
So I disabled RLS on

folders

folders

table, and now it was working perfectly.

Project ID: hgqnfohuvgxsdcoymawt

I really don't have any idea on how to fix this, so I would really appreciate your help!

Realtime not working with RLS

Similar Threads

Realtime not working with RLS

Similar Threads

Similar Threads

Similar Threads