trove schema migration length argument not valid for type Text

[Sean McCully]

Length is not a valid argument for text type in postgres databases.

CRITICAL root [-] ProgrammingError: (psycopg2.ProgrammingError) type modifier is not allowed for type "text"

[SQL: '\nCREATE TABLE modules (\n\tid VARCHAR(64) NOT NULL, \n\tname VARCHAR(255) NOT NULL, \n\ttype VARCHAR(255) NOT NULL, \n\tcontents TEXT(16777215) NOT NULL, \n\tdescription VARCHAR(255), \n\ttenant_id VARCHAR(64), \n\tdatastore_id VARCHAR(64), \n\tdatastore_version_id VARCHAR(64), \n\tauto_apply BOOLEAN NOT NULL, \n\tvisible BOOLEAN NOT NULL, \n\tlive_update BOOLEAN NOT NULL, \n\tmd5 VARCHAR(32) NOT NULL, \n\tcreated TIMESTAMP WITHOUT TIME ZONE NOT NULL, \n\tupdated TIMESTAMP WITHOUT TIME ZONE NOT NULL, \n\tdeleted BOOLEAN NOT NULL, \n\tdeleted_at TIMESTAMP WITHOUT TIME ZONE, \n\tPRIMARY KEY (id), \n\tCONSTRAINT "UQ_type_tenant_datastore_datastore_version_name" UNIQUE (type, tenant_id, datastore_id, datastore_version_id, name, deleted_at)\n)\n\n']

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/311032
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=918ddefd8de960bdfd32b7d9559cedf7b2f82a37
Submitter: Jenkins
Branch: master

commit 918ddefd8de960bdfd32b7d9559cedf7b2f82a37
Author: Sean McCully <email address hidden>
Date: Fri Apr 29 00:40:13 2016 -0500

    Schema migrations fail for postgresql backend

    Schema migrations pass length as an argument for all database backends
    which may not be valid. Length is not a valid argument for PostgreSQL
    databases.

    Change-Id: If50fc894d342f1b172e579489f20468ad3964787
    Closes-Bug: #1576517

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/trove 6.0.0.0b2 development milestone.