The error that I get is "service_users.user_id doe...
# helpo
oscar_gallog
01/30/2022, 8:51 PMThe error that I get is "service_users.user_id does not exist. But it does exist...kind of weird
g
garyaustin
01/30/2022, 8:55 PMDo you have RLS on service_users?
o
oscar_gallog
01/30/2022, 8:56 PMNot yet
oscar_gallog
01/30/2022, 8:56 PMDo I need to activate them first?
g
garyaustin
01/30/2022, 8:56 PMNo, but RLS on those tables could prevent you from reading them, depending on how you have it set.
garyaustin
01/30/2022, 8:58 PMAre all the tables in the public schema?
o
oscar_gallog
01/30/2022, 8:58 PMOh yeah, RLS goes from top to bottom, good point
g
garyaustin
01/30/2022, 9:00 PMSometimes you need a security definer function to check ids and such in tables you don't want users having read access to.
garyaustin
01/30/2022, 9:00 PMBut that is for the future, if you have it off
garyaustin
01/30/2022, 9:01 PMAre you getting this error writing the policy?
o
oscar_gallog
01/30/2022, 9:06 PMI get the error when I click on save_policy, and the error:
Error adding policy: column service_users.user_id does not exist
g
garyaustin
01/30/2022, 9:11 PMcheck spelling, try putting public.service_users in front of both cases (should't be needed though)
o
oscar_gallog
01/30/2022, 9:13 PMGood point, let me try it
g
garyaustin
01/30/2022, 9:30 PMI just tested this on a table with check on another table and it goes thru.
(EXISTS ( SELECT 1 FROM notes WHERE notes.uid = uid()))
Are you sure on spelling/caps etc.?