Supabase Clerk.com User ID not connecting/updating/Saving
Hello,
I use clerk.com for user management inside my app which i build with Bolt.New, and I use Supabase for the data etc.
The issue is that clerk handles the authentication. But when I want to save a property it says "user not authenticated on Supabase" and the user is on Supabase and it refuses to save. On Supabase the Clerk_user_id is uuid and on clerk it is text. But Supabase is not letting me edit the column.
Can someone help me out with a fix for this?
Thanks in advance.
2 Replies
You have to drop the column and recreate it is easiest way to change from UUID to text. Or possibly ask your AI for how to use Postgres SQL to change it which can be done, but a bit tricky.
Thanks, ..I have tried it i have changed it from UUID to text. I first dropped the policies and then changed it and put back the policy..