PostgreSql 9 doesnt have datetime data type

Description

When i upgraded from 2.5 to 3.0.2 postgresql, the history table cant be created since liquibase create sql contains datetime datatype which is invalid for PostgreSql 9.1

Here is the trace;
INFO 13.07.2013 15:01:liquibase: Creating database history table with name: public.s_db_gunce
15:01:38.657 [main] WARN - SQL Error: 0, SQLState: null o.h.e.jdbc.spi.SqlExceptionHelper
15:01:38.658 [main] ERROR - liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE public.s_db_gunce_klt (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME, LOCKEDBY VARCHAR(255), CONSTRAINT PK_S_DB_GUNCE_KLT PRIMARY KEY (ID)); on jdbcostgresql://localhost/jesmedicaINSERT INTO public.s_db_gunce_klt (ID, LOCKED) VALUES (1, FALSE): ERROR: type "datetime" does not exist
Position: 91 o.h.e.jdbc.spi.SqlExceptionHelper

Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE public.s_db_gunce_klt (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED DATETIME, LOCKEDBY VARCHAR(255), CONSTRAINT PK_S_DB_GUNCE_KLT PRIMARY KEY (ID)); on jdbcostgresql://localhost/jesmedicaINSERT INTO public.s_db_gunce_klt (ID, LOCKED) VALUES (1, FALSE): ERROR: type "datetime" does not exist
Position: 91
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) ~[liquibase-core-3.0.2.jar:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) ~[liquibase-core-3.0.2.jar:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:64) ~[liquibase-core-3.0.2.jar:na]
at liquibase.database.AbstractJdbcDatabase.checkDatabaseChangeLogLockTable(AbstractJdbcDatabase.java:778) ~[liquibase-core-3.0.2.jar:na]
at liquibase.Liquibase.checkDatabaseChangeLogTable(Liquibase.java:604) ~[liquibase-core-3.0.2.jar:na]
at liquibase.Liquibase.forceReleaseLocks(Liquibase.java:640) ~[liquibase-core-3.0.2.jar:na]
at com.jes.application.hibernate.service.BaseDBService$1.execute(BaseDBService.java:81) ~[bin/:na]
... 31 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: type "datetime" does not exist
Position: 91
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[postgresql-9.2-1003-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[postgresql-9.2-1003-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.2-1003-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[postgresql-9.2-1003-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) ~[postgresql-9.2-1003-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395) ~[postgresql-9.2-1003-jdbc4.jar:na]
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) ~[c3p0-0.9.1.jar:0.9.1]
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:86) ~[liquibase-core-3.0.2.jar:na]
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:49) ~[liquibase-core-3.0.2.jar:na]
... 37 common frames omitted

Environment

Linux Mint, PostreSql 9.1.9, Oracle Java 7

Reporter

HakanC

Components

Fix versions

Affects versions

Priority

Major
Configure