migration 144 doesn't support PostgreSQL

[Dan Prince]

Using the latest Nova Grizzly I'm seeing the following exceptions when running 'nova-manage db sync' with PostgreSQL:

2012-11-28 14:17:08 13991 CRITICAL nova [-] (ProgrammingError) operator does not exist: boolean = integer
LINE 3: WHERE compute_nodes.deleted = 0 AND services.deleted = 0
                                    ^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
 'SELECT services.host, compute_nodes.hypervisor_hostname \nFROM compute_nodes JOIN services ON compute_nodes.service_id = services.id \nWHERE compute_nodes.deleted = %(deleted_1)s AND services.deleted = %(deleted_2)s' {'deleted_2': 0, 'deleted_1': 0}

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/17073

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/17073
Committed: http://github.com/openstack/nova/commit/a4196ff553cc85a455f2e05a3abecee64ca8b9d2
Submitter: Jenkins
Branch: master

commit a4196ff553cc85a455f2e05a3abecee64ca8b9d2
Author: Dan Prince <email address hidden>
Date: Wed Nov 28 14:39:34 2012 -0500

    Update migration so it supports PostgreSQL.

    Updates the 'deleted' columns so that they are treated as
    Booleans instead of integers. This makes it so that
    144_add_node_to_migrations.py works on both MySQL and PostgreSQL.

    Fixes LP Bug #1084208.

    Change-Id: Ibff1c45117e47126a255b2a1df5e915c881cb5c1