View Issue Details

IDProjectCategoryView StatusLast Update
0004112SymmetricDSBugpublic2019-11-01 08:44
ReporterpmarzulloAssigned Topmarzullo 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.4 
Target Version3.10.5Fixed in Version3.10.5 
Summary0004112: Postgres Time column type can't be converted to Timestamp column type without a cast when restoring the data
DescriptionDuring Symmetric table upgrade, when a column type of Time is changed to Timestamp, the restoring of the data needs a case when converting from Time to Timestamp.
Additional Informationdate_trunc('DAY', localtimestamp) + time_column_value
Tagsdialect: postgresql

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 5425817e

2019-10-14 14:55:56

Philip Marzullo

Details Diff
0004112: Postgres Time column type can't be converted to Timestamp
column type without a cast when restoring the data

0004112
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2019-10-14 14:55 pmarzullo New Issue
2019-10-14 14:55 pmarzullo Status new => assigned
2019-10-14 14:55 pmarzullo Assigned To => pmarzullo
2019-10-14 14:55 pmarzullo Tag Attached: dialect: postgresql
2019-10-14 14:58 pmarzullo Status assigned => resolved
2019-10-14 14:58 pmarzullo Resolution open => fixed
2019-10-14 14:58 pmarzullo Fixed in Version => 3.10.5
2019-10-14 15:00 Changeset attached => SymmetricDS 3.10 5425817e
2019-11-01 08:44 admin Status resolved => closed