View Issue Details

IDProjectCategoryView StatusLast Update
0002261SymmetricDSBugpublic2019-05-13 16:19
ReportermoizhbAssigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.7.12 
Target VersionFixed in Version 
Summary0002261: Schema from Postgres outputs TIMESTAMPTZ that is not compatible with other databases
Description[server-000] - AcknowledgeService - The outgoing batch 001-17 failed. Unknown data type: "TIMESTAMPTZ"; SQL statement:

H2 database does not understand Timestamp with timezone datatype
Steps To ReproduceDuring syncing the schema from server(pg) to client(h2) and if a table has column with data type as timestamp with timezone.
Additional Information----Error on server----

[server-000] - AcknowledgeService - The outgoing batch 001-17 failed. Unknown data type: "TIMESTAMPTZ"; SQL statement:
CREATE TABLE "POSTS"(
    "ID" INTEGER NOT NULL AUTO_INCREMENT,
    "TITLE" VARCHAR(100) NULL,
    "POST" VARCHAR(2147483647) NULL,
    "CREATED_AT" TIMESTAMPTZ,
    "UPDATED_AT" TIMESTAMPTZ,
    PRIMARY KEY ("ID")
) [50004-176]


----Error on client----
Caused by: org.h2.jdbc.JdbcSQLException: Unknown data type: "TIMESTAMPTZ"; SQL statement:
CREATE TABLE "POSTS"(
    "ID" INTEGER NOT NULL AUTO_INCREMENT,
    "TITLE" VARCHAR(100) NULL,
    "POST" VARCHAR(2147483647) NULL,
    "CREATED_AT" TIMESTAMPTZ,
    "UPDATED_AT" TIMESTAMPTZ,
    PRIMARY KEY ("ID")
) [50004-176]

Tagsddl/schema

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-04-09 13:42 moizhb New Issue
2019-04-23 13:10 elong Tag Attached: ddl/schema
2019-05-13 16:19 elong Summary Syncing Schema from Postgres to H2 database => Schema from Postgres outputs TIMESTAMPTZ that is not compatible with other databases