View Issue Details

IDProjectCategoryView StatusLast Update
0004113SymmetricDSBugpublic2019-11-15 14:04
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.0Fixed in Version3.11.0 
Summary0004113: 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.11 827395b3

2019-10-14 15:02:10

Philip Marzullo

Details Diff
0004113: Postgres Time column type can't be converted to Timestamp
column type without a cast when restoring the data
Affected Issues
0004113
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 18:57 pmarzullo New Issue
2019-10-14 18:57 pmarzullo Status new => assigned
2019-10-14 18:57 pmarzullo Assigned To => pmarzullo
2019-10-14 18:57 pmarzullo Description Updated View Revisions
2019-10-14 18:58 pmarzullo Additional Information Updated View Revisions
2019-10-14 19:02 pmarzullo Status assigned => resolved
2019-10-14 19:02 pmarzullo Resolution open => fixed
2019-10-14 19:02 pmarzullo Fixed in Version => 3.11.0
2019-10-14 19:02 pmarzullo Tag Attached: dialect: postgresql
2019-10-14 20:00 Changeset attached => SymmetricDS 3.11 827395b3
2019-11-15 14:04 admin Status resolved => closed