Request to modify postgres model to use timezone-aware timestampz

[spring-projects-issues]

Gary P Russo opened BATCH-2734 and commented

To avoid any dependency or conflicts with the client time zone, it is considered a best practice to use Postgres TIMESTAMPZ instead of TIMESTAMP.

The postgres table creation script is currently using the TIMESTAMP data type. 

https://github.com/spring-projects/spring-batch/blob/master/spring-batch-core/src/main/resources/org/springframework/batch/core/schema-postgresql.sql

 

---

Affects: 4.0.1

Reference URL: http://www.postgresqltutorial.com/postgresql-timestamp/

[fmbenhassine]

FTR, an attempt was made to implement this in #4209. Due to the issues that popped up in that attempt, this feature is delayed to a future version.