when i tried to create a column with the data type "TIMESTAMP WITHOUT TIME ZONE" in postgresql
it's always created in the database as "TIMESTAMP WITH TIME ZONE" , so is there's any workarounds or solutions for this problem ?
<addColumn tableName="myTable">
<column name="date_added" type="TIMESTAMP WITHOUT TIME ZONE">
<constraints nullable="false" />
</column>
</addColumn>
btw, this issue is on jira:
http://liquibase.jira.com/browse/CORE-877
Best Answer
Instead of using the tag and switch completely from XML to sql, you could modify the resulting generated SQL using the tag which is valid across the whole changeset: http://www.liquibase.org/documentation/modify_sql.html
for example in your case you would have this: