Drop unique index doesn't work for PostgreSQL

[Legend-Master]

Description

After removing unique constraint on a column and on the next schema sync to Postgres, I get cannot drop index test_user_id_key because constraint test_user_id_key on table orders requires it from sea-orm running DROP INDEX "test_user_id_key"

This works for SQLite though

Steps to Reproduce

1. Add #[sea_orm(unique)] to a column, and run schema sync
2. Remove #[sea_orm(unique)] and run again

Expected Behavior

unique constraint removed

Actual Behavior

Schema sync failed

Reproduces How Often

Always

Workarounds

Drop the constraint manually

Versions

2.0.0-rc.37

[sinder38]

This is a sea_query bug.
it is being fixed rn:
SeaQL/sea-query@f3c0b83

[tyt2y3]

oh well yes I am about to push the sea-orm fix, thanks @sinder38 you're very up to date!