Error SQL query

So i am trying to create policy(RLS) on supabase to delete a row using id, it keep showing this error ( uuid = bigint ) also tried changing the type on user_id to uuid on table column but still same thing.
No description
No description
3 Replies
Ad Intellegent
@Web3TΞGA_🛡 keep your id column as BIGINT, and add a separate user_id column of type UUID to use for RLS policies. This avoids the type mismatch error
Web3TΞGA_🛡
Web3TΞGA_🛡OP3w ago
Thanks it working now!
Ad Intellegent
Sounds good

Did you find this page helpful?