Creating Postgres Varchar Array Columns with Liquibase

Question

Since using Arrays in columns is still more of a NoSQL than RDBMS way of storing a list, I understand that Liquibase doesn't officially support the type. However, when I use the PSQL statements from the docs, I get the following:

<column name="widgets" type="varchar(8)[]" />

Trace output:

liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "("
...
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "("

The vary same DDL works as expected when run from the PSQL command line.

Answer 1

It must be a bug of sorts in the PSQL parser. Just adding a space fixes it.

<column name="widgets" type="varchar(8) []" />

Liquibase must be changing the SQL string in some mior way.