Simple RLS Policy with Join

I would think this would work:
(role() = 'authenticated'::text) AND (authorId.id = uuid())

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
Was this page helpful?