← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1599840] [NEW] Remove foreign key during db upgrade not remove unique constraint for it

 

Public bug reported:

If in alembic db upgrade script function alembic.migration.remove_fks_from_table() is used it will not remove unique constraint for such foreign key if it was created.
There should be possibility to remove such constraints from db.
Because droping such constraints is littlebit different for mysql and postgresql (different names of constraint) there should be introduced new function "remove_constraints" which would be also used during remove foreign keys.

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1599840

Title:
  Remove foreign key during db upgrade not remove unique constraint for
  it

Status in neutron:
  New

Bug description:
  If in alembic db upgrade script function alembic.migration.remove_fks_from_table() is used it will not remove unique constraint for such foreign key if it was created.
  There should be possibility to remove such constraints from db.
  Because droping such constraints is littlebit different for mysql and postgresql (different names of constraint) there should be introduced new function "remove_constraints" which would be also used during remove foreign keys.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1599840/+subscriptions


Follow ups