Based on many tutorials, there is no issue linking a foreign key between a #int8 data and the auth schema containing a UUID data in Supabase. However, I am having this issue when attempting to create such a foreign key link. Any advise would be greatly appreciated.
The only workaround I found was to create a new 'users' table and make sure the its primary ID is UUID rather than the default #int8. Thank you
Supabase auth foreign key #int8 --> UUID mismatch error
3 replies