PostgreSQL timezone format

General Discussion
1

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

2

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

3

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.

4

Thanks. I added the link in jira.


Nathan

5

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: 


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