Hello,
I’ve upgrade to the latest liquibase (version 4.18.0) in my java project. I was previously using version 4.8.0. After the upgrade, i see the following error:
Here is my liquibase xml:
<?xml version=*"1.0"* encoding=*"utf-8"* standalone=*"no"*?>
<databaseChangeLog logicalFilePath=*"system-common.xml"*
xmlns=*"http://www.liquibase.org/xml/ns/dbchangelog"*
xmlns:ext=*"http://www.liquibase.org/xml/ns/dbchangelog-ext"*
xmlns:xsi=*"http://www.w3.org/2001/XMLSchema-instance"*
xsi:schemaLocation=*"http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd"* >
<property name=*"now"* value=*"now() AT TIME ZONE 'UTC'"*
dbms=*"postgresql"* />
<changeSet author=*"my name"*
id=*"ee9c0a46-ecb1-4eda-996e-a93284d1b6b3"* >
<createTable tableName=*"group"*>
<column name=*"id"* type=*"UUID"* >
<constraints nullable=*"false"* primaryKey=*"true"*
primaryKeyName=*"PK_Common_Group"* />
</column>
<column name=*"group_type"* type=*"text"* >
<constraints nullable=*"false"* />
</column>
<column name=*"display_name"* type=*"text"* >
<constraints nullable=*"false"* />
</column>
<column name=*"date"* type=*"timestamp with time zone"* >
<constraints nullable=*"false"* />
</column>
</createTable>
<rollback>
DROP table IF EXISTS group;
</rollback>
</changeSet>
<changeSet author=*"my name"*
id=*"a8c8b2ef-f5fd-4a9d-86be-589c270292b1"* >
<insert tableName=*"group"*>
<column name=*"id"* value=*"bc2ad4da-b964-4f3f-9024-65a92aa25473"* />
<column name=*"group_type"* value=*"bootstrap"* />
<column name=*"display_name"* value=*"bootstrap"* />
<column name=*"date"* valueDate=*"${now}"* />
</insert>
<insert tableName=*"group"*>
<column name=*"id"* value=*"82018faf-73e7-440c-b6ab-5d7917cb8961"* />
<column name=*"group_type"* value=*"createTenant"* />
<column name=*"display_name"* value=*"create tenant"* />
<column name=*"date"* valueDate=*"${now}"* />
</insert>
<insert tableName=*"group"*>
<column name=*"id"* value=*"00f5e643-28ca-43d1-a1b8-826a3e8b70ab"* />
<column name=*"group_type"* value=*"updateTenant"* />
<column name=*"display_name"* value=*"update tenant"* />
<column name=*"date"* valueDate=*"${now}"* />
</insert>
<insert tableName=*"group"*>
<column name=*"id"* value=*"5a1e5a2e-4910-418c-a6cd-94f1014e8be4"* />
<column name=*"group_type"* value=*"deleteTenant"* />
<column name=*"display_name"* value=*"delete tenant"* />
<column name=*"date"* valueDate=*"${now}"* />
</insert>
<insert tableName=*"group"*>
<column name=*"id"* value=*"9b83d950-aa90-4df0-bae2-104e211ee806"* />
<column name=*"group_type"* value=*"activateTenant"* />
<column name=*"display_name"* value=*"activate tenant"* />
<column name=*"date"* valueDate=*"${now}"* />
</insert>
</changeSet>
<changeSet author=*"my name"*
id=*"d5ffd0eb-153d-40dc-adf7-ed4674d3f872"* >
<createTable tableName=*"event"*>
<column name=*"id"* type=*"UUID"* >
<constraints nullable=*"false"* primaryKey=*"true"*
primaryKeyName=*"PK_Common_Event"* />
</column>
<column name=*"event_type"* type=*"text"* >
<constraints nullable=*"false"* />
</column>
<column name=*"display_name"* type=*"text"* >
<constraints nullable=*"false"* />
</column>
<column name=*"service"* type=*"text"* >
<constraints nullable=*"false"* />
</column>
<column name=*"group_id"* type=*"UUID"* >
<constraints nullable=*"false"*
foreignKeyName=*"FK_Common_Group_Event"* references=*"group(id)"* />
</column>
<column name=*"date"* type=*"timestamp with time zone"* >
<constraints nullable=*"false"* />
</column>
</createTable>
<rollback>
DROP table IF EXISTS "event";
</rollback>
<addUniqueConstraint
columnNames=*"event_type, service"*
constraintName=*"unique_event_type_and_service"* tableName=*"event"* />
</changeSet>
</databaseChangeLog>
Any help on what i need to change, would be greatly appreciated!
Thanks in advance!