fix-alembic-postgresql-enum-duplicate

The psycopg2 DuplicateObject error occurs when Alembic attempts to create the same PostgreSQL ENUM type multiple times. This Skill identifies these double-creation conflicts and corrects column definitions to prevent duplicate ENUM generation.

You can fix Alembic migration ENUM conflicts by running the `fix_alembic_postgresql_enum_duplicate.py` script as part of your workflow. It modifies column definitions to avoid duplicate ENUM type creation.

Double creation of ENUM types is caused by incorrect handling of ENUM type definitions in Alembic migrations, where multiple scripts attempt to define the same PostgreSQL ENUM type, triggering a DuplicateObject error.

Yes, resolving PostgreSQL ENUM duplicate errors requires both psycopg2 and Alembic. This Skill operates within environments using Alembic with PostgreSQL to identify and correct duplicate ENUM type creation.

The best way to prevent DuplicateObject errors during PostgreSQL database migration is to ensure correct handling of ENUM type definitions. This Skill modifies column definitions to stop Alembic from attempting duplicate ENUM type creation.