cli
cli copied to clipboard
db diff cannot detect enum values added via ALTER TYPE ADD VALUE
Describe the bug npx supabase db diff generates migration to recreate enum type, even though values were already added successfully using ALTER TYPE ... ADD VALUE.
To Reproduce
- Use declarative schema enum
- Create migration with "npx supabase migration new ..." with add enum values using ALTER TYPE vehicleCategory ADD VALUE 'newValue'
- Apply migration successfully to remote database
- Run npx supabase db diff
- Diff generates full enum recreation instead of recognizing existing values
Expected behavior Diff should detect enum already has all required values and generate no migration.