Simple RLS Policy with Join
I would think this would work:
Here
I get column "authorId" does not exist when trying to create the policy, but it does exist. It is an fk field.
J
Here
authorId is a FK to profiles.id. I simply want to make sure a user can't insert a post where the author is someone else.I get column "authorId" does not exist when trying to create the policy, but it does exist. It is an fk field.
J