Postgress migrations/second push fail due to trying to recreate constraints
I am using postgress on supabase, checked on docker as well same issue is replicated.
And unable to to push after pushing second time
Is there something fundamentally wrong that I am doing.
The migration files generated are correct but while pushing there is extra statements for unique id constraints.
This is a smaller schema in which I am able to replicate the issue.
package.json
drizzle.config.ts
test.ts [sample test schema to demonstrate issue]
Replication steps and related Info
Initial generate
\0000_daffy_jackal.sql
Pushing the schemas [successfully added]
Change made in userProfile schema
Generate migrations
The sql file seems correct
\0001_milky_shiver_man.sql