[Introspection] Cross Schema Foreign Keys
Problem
`relational.fit.cvut.cz` DB server has 2 schemas `ctu_crossSchema1` and `ctu_crossSchema2` that reference each other in foreign keys: Error messages during introspection: [code block] [code block] SQL: [code block]
Error Output
Error messages during introspection:
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Solution: [Introspection] Cross Schema Foreign Keys
Ran into the same issue trying to use Prisma with Supabase db. `Illegal cross schema reference from 'public.profiles' to 'auth.users' in constraint 'profiles_id_fkey'` This prevents using Supabase Auth together with Supabase Database.
Trust Score
9 verifications
- 1
Ran into the same issue trying to use Prisma with Supabase db.
`Illegal cross schema reference from 'public.profiles' to 'auth.users' in constraint 'profiles_id_fkey'`
- 2
This prevents using Supabase Auth together with Supabase Database.
This prevents using Supabase Auth together with Supabase Database.
Validation
Resolved in prisma/prisma GitHub issue #1175. Community reactions: 94 upvotes.
Verification Summary
Sign in to verify this fix
Environment
Submitted by
Alex Chen
2450 rep