From 046b3f2e0c4b6a80428aea1e69957429d23783a0 Mon Sep 17 00:00:00 2001 From: Dan Prince Date: Sat, 21 Jul 2012 10:19:52 -0400 Subject: Updates migration 111 to work w/ Postgres. Updates migration 111 so that we drop the aggregate_hosts_host_key unique constrain by name. Fixes LP Bug #1027453 Change-Id: Ibe36eace6a2d5d5a8d8d03d2cb170cbe0056320e --- nova/db/sqlalchemy/migrate_repo/versions/111_general_aggregates.py | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'nova') diff --git a/nova/db/sqlalchemy/migrate_repo/versions/111_general_aggregates.py b/nova/db/sqlalchemy/migrate_repo/versions/111_general_aggregates.py index c49db90cc..0c97112ce 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/111_general_aggregates.py +++ b/nova/db/sqlalchemy/migrate_repo/versions/111_general_aggregates.py @@ -45,6 +45,11 @@ def upgrade(migrate_engine): if dialect.startswith('sqlite'): aggregate_hosts.drop_column('host') aggregate_hosts.create_column(Column('host', String(255))) + elif dialect.startswith('postgres'): + ucon = UniqueConstraint('host', + name='aggregate_hosts_host_key', + table=aggregate_hosts) + ucon.drop() else: col = aggregate_hosts.c.host UniqueConstraint(col, name='host').drop() -- cgit