You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
pg-delta's "Supabase-managed schema" filter excludes the entire auth / storage schemas, which also drops user-defined objects living inside them (e.g. a trigger attached to auth.users). migra picks these up correctly.
Reproduction
Create a trigger on auth.users in the local database.
Run either of:
supabase db diff --schema auth,storage -f temp
supabase db diff -f temp
The user-defined trigger is missing from the generated migration.
Re-run with --use-migra — the trigger appears as expected.
Expected behavior
The filter should distinguish between Supabase-managed objects (which should remain ignored) and user-defined objects inside managed schemas (which should be diffed). The schema-level exclusion is too coarse.
Notes
Behavior is consistent across --schema auth,storage and the default invocation.
Summary
pg-delta's "Supabase-managed schema" filter excludes the entire
auth/storageschemas, which also drops user-defined objects living inside them (e.g. a trigger attached toauth.users).migrapicks these up correctly.Reproduction
auth.usersin the local database.--use-migra— the trigger appears as expected.Expected behavior
The filter should distinguish between Supabase-managed objects (which should remain ignored) and user-defined objects inside managed schemas (which should be diffed). The schema-level exclusion is too coarse.
Notes
--schema auth,storageand the default invocation.References