PostgreSQL timezone format

Hello, I’m using Liquibase last version 3.x and 


And then deleted the entire bd and liquidbase update…


The generated timestamps are with timezone!, again wrong. How is possible?


Conclusion:


I need to work with liquibase with postgres timezones without timezones.

Is this a bug or is this something than never will change because there is a really good reason?.


Kind regars,


Fran

The problem comes from trying to handle data types in both database-specific and database-independent formats. I’m going to look at better ways of handling it with 3.2. I created https://liquibase.jira.com/browse/CORE-1695 to track the issue.


For now, you’ll have to fix the generated xml to “timestamp without timezone” and then it should work.


Or you could create an extension (liquibase.org/extensions) that overrides the TimestampType class to return “TIMESTAMP” instead of “TIMESTAMP WITH TIMEZONE”


Nathan

https://liquibase.jira.com/browse/CORE-1695 seems to be related to issue http://liquibase.jira.com/browse/CORE-877 found in similar thread:
You can mark this relation in your JIRA if you like.

Thanks. I added the link in jira.


Nathan

According to postgres documentation default for timestamp is wothout timezone NOT with

http://www.postgresql.org/docs/9.2/static/datatype-datetime.html


I’ve made a simple patch for this problem: 


  1. <span);
  2. +        }
  3.          return super.toDatabaseDataType(database);
  4.      }
  5.