[dev.icinga.com #9047] PostgreSQL schema sets default timestamps w/o time zone

[icinga-migration]

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

Created by mfriedrich on 2015-04-12 13:20:48 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2015-10-30 17:01:09 +00:00)
Target Version: (none)
Last Update: 2016-12-22 20:23:30 +00:00 (in Redmine)

Icinga Version: v2.3.0-82-gdda273d
OS Version: any

---

The timestamp columns in the PostgreSQL schema are defined as timestamp with time zone but their default values lack the UTC time zone offset +00. Thus default timestamps are converted to local time in the zone specified by PostgreSQL's configuration before being displayed to the client.

Check #9027 for patches.

Changesets

2015-10-30 16:59:41 +00:00 by mfriedrich a3b767a

IDO: Import 1.14.0 schema updates

fixes #9047
fixes #9832

2016-12-22 20:25:07 +00:00 by mfriedrich 002fbbd

Revert "IDO: Import 1.14.0 schema updates"

This reverts commit a3b767af72dd73570d49daa3ad1b47398c14e6db.

refs #9047
refs #9832

---

Relations:

• relates #9047
• copied_to #9047

[icinga-migration]

Updated by mfriedrich on 2015-04-12 13:20:51 +00:00

• Copied From set to 9027

[icinga-migration]

Updated by berk on 2015-05-18 12:18:17 +00:00

• Target Version changed from 1.14 to Backlog

[icinga-migration]

Updated by mfriedrich on 2015-06-12 17:05:09 +00:00

• Target Version changed from Backlog to 1.14

[icinga-migration]

Updated by mfriedrich on 2015-08-04 19:04:20 +00:00

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

[icinga-migration]

Updated by mfriedrich on 2015-08-04 19:05:19 +00:00

• Relates set to 9832

[icinga-migration]

Updated by mfriedrich on 2015-10-30 17:01:09 +00:00

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

Applied in changeset a3b767a.

[icinga-migration]

Updated by mfriedrich on 2016-12-22 20:23:30 +00:00

• Target Version deleted 1.14
• Done % changed from 100 to 0