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
Write a migration that enables citext on postgresql:
CREATE EXTENSION IF NOT EXISTS citext;
Apply the migration on a clean postgresql db
Run the command migration command fresh to clean the database cargo run -- fresh
The command returns an error:
...
Dropping all types
Dropping type 'citext'
Execution Error: error returned from database: cannot drop type citext because extension citext requires it
Expected Behavior
The fresh command executes without error.
Either it deletes the extension or it only deletes types that can be deleted or it continues without an error
Description
Steps to Reproduce
citext
on postgresql:fresh
to clean the databasecargo run -- fresh
Expected Behavior
The fresh command executes without error.
Either it deletes the extension or it only deletes types that can be deleted or it continues without an error
Actual Behavior
Command runs with an error
See: https://github.com/SeaQL/sea-orm/blob/master/sea-orm-migration/src/migrator.rs#L330-L342
Reproduces How Often
Always
Workarounds
citext
extensionfresh
command and use other commands likerefresh
and write my own down script to drop thecitext
extension before handReproducible Example
CREATE EXTENSION IF NOT EXISTS citext;
sea-orm-cli migrate fresh
Versions
The text was updated successfully, but these errors were encountered: