https://supabase.com/ logo
RLS - Error
и

иuғe

05/24/2023, 9:28 PM
I am using next-auth in supabase , I have user table and Idea table as one-many relationship , I tried to create policy for delete own user idea but I couldn't here is my condition for deleting next_auth.uid() = userId

https://cdn.discordapp.com/attachments/1111043110886187069/1111043270684971028/image.png

here is the Idea columns
g

garyaustin

05/24/2023, 9:32 PM
Assuming your function works you have to put names (columns/tables) in double quotes if they have capital letters to use them. You should NOT use capitals in Postgres for this reason, although it is permitted.