[dev.icinga.com #13221] PostgreSQL: Don't use timestamp with timezone for UNIX timestamp columns

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/13221

Created by elippmann on 2016-11-17 11:17:52 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2016-11-18 10:42:08 +00:00)
Target Version: 2.6.0
Last Update: 2016-12-13 07:30:41 +00:00 (in Redmine)

Icinga Version: 2.5.4
Backport?: Not yet backported
Include in Changelog: 1

---

Changesets

2016-11-17 11:42:20 +00:00 by elippmann 4051664

ido-pgsql: Change timestamp columns to timestamp without time zone

refs #13221

2016-11-17 11:42:24 +00:00 by elippmann 3e06801

ido-pgsql: Use timestamp without time zone in from_unixtime and to_timestamp functions

refs #13221

2016-11-17 11:43:05 +00:00 by elippmann 0241cf9

ido-pgsql: Bump schema version to 1.14.2

refs #13221

2016-11-17 11:44:30 +00:00 by elippmann eddf579

ido-pgsql: Upgrade timestamp columns to timestamp without time zone

refs #13221

2016-11-18 10:11:50 +00:00 by elippmann aadfedc

ido-pgsql: Change timestamp columns to timestamp without time zone

refs #13221

2016-11-18 10:11:50 +00:00 by elippmann 69d3016

ido-pgsql: Use timestamp without time zone in from_unixtime and to_timestamp functions

refs #13221

2016-11-18 10:11:50 +00:00 by elippmann 27f7aa3

ido-pgsql: Bump schema version to 1.14.2

refs #13221

2016-11-18 10:11:50 +00:00 by elippmann e4a9564

ido-pgsql: Upgrade timestamp columns to timestamp without time zone

refs #13221

2016-11-18 10:39:14 +00:00 by mfriedrich 1679488

DB IDO: Bump schema version to 1.14.2

fixes #10502
fixes #13221

[icinga-migration]

Updated by elippmann on 2016-11-17 12:11:53 +00:00

• Status changed from Assigned to New
• Assigned to deleted elippmann

[icinga-migration]

Updated by mfriedrich on 2016-11-18 10:38:35 +00:00

• Status changed from New to Assigned
• Assigned to set to mfriedrich

[icinga-migration]

Updated by mfriedrich on 2016-11-18 10:42:08 +00:00

• Status changed from Assigned to Resolved
• Done % changed from 0 to 100

Applied in changeset 1679488.

[icinga-migration]

Updated by gbeutner on 2016-12-13 07:30:41 +00:00

• Subject changed from PostgreSQL: Don't use timestamp with timezone for unix timestamp columns to PostgreSQL: Don't use timestamp with timezone for UNIX timestamp columns