trove schema migration length argument not valid for type Text

Bug #1576518 reported by Sean McCully
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
New
Undecided
Unassigned

Bug Description

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']

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.