psycopg2.InternalError: ALTER TYPE ... ADD cannot run inside a transaction block

Issue #26 resolved
created an issue

PostgreSQL can't modify ENUM types with transactions.

ALTER TYPE something ADD VALUE 'deleted' AFTER 'listed';

Would be great to disable transactions for some migrations.

Comments (3)

  1. ollyc repo owner

    I've just added support for this. Upgrade to 5.0.5 and add this line to your migration file and it should work:

    __transactional__ = False
  2. Log in to comment