You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When subscribed to postgres_changes and specifying a row level filter, websocket inspector shows that rows outside of the provided filter are being sent to the client.
To Reproduce
Given the following table:
create table
public.test_realtime (
id bigint generated by default as identity not null,
data textnull,
created_at timestamp with time zonenull default now(),
constraint test_realtime_pkey primary key (id)
) tablespace pg_default;
INSERT into test_realtime (data) VALUES ('Test 1');
INSERT into test_realtime (data) VALUES ('Test 2');
INSERT into test_realtime (data) VALUES ('Test 3');
INSERT into test_realtime (data) VALUES ('Test 4');
INSERT into test_realtime (data) VALUES ('Test 5');
INSERT into test_realtime (data) VALUES ('Test 6');
INSERT into test_realtime (data) VALUES ('Test 7');
INSERT into test_realtime (data) VALUES ('Test 8');
INSERT into test_realtime (data) VALUES ('Test 9');
Bug report
Describe the bug
When subscribed to
postgres_changes
and specifying a row level filter, websocket inspector shows that rows outside of the provided filter are being sent to the client.To Reproduce
Given the following table:
And the following code:
In Supabase Inspector:
Console Behavior:
Websocket Behavior:
Expected behavior
Neither websocket nor console should produce logs for rows outside of the filter.
System information
Additional context
In reference to: supabase-community/realtime-csharp#27
The text was updated successfully, but these errors were encountered: