After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 571801 - SET TIMEZONE UTC should read SET TIMEZONE 'UTC'
SET TIMEZONE UTC should read SET TIMEZONE 'UTC'
Status: RESOLVED FIXED
Product: planner
Classification: Other
Component: General
0.14.x
Other All
: Normal normal
: ---
Assigned To: planner-maint
planner-maint
Depends on:
Blocks:
 
 
Reported: 2009-02-15 03:20 UTC by Not Used
Modified: 2009-04-14 17:27 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Use 'UTC' everywhere so PostgreSQL stops complaining. (1.23 KB, patch)
2009-02-15 04:01 UTC, Not Used
none Details | Review

Description Not Used 2009-02-15 03:20:13 UTC
Please describe the problem:
The SQL call to SET TIMEZONE UTC failes on PostgreSQL 8.0.X (I'm running Gentoo with PostgreSQL 8.0.15 and timezonedata 2008i). If we change this command to SET TIMEZONE 'UTC' it works as expected and is doing as the doc says.

This failure prevent writing to a PostgreSQL database version 8.0.X

Steps to reproduce:
1. Install and configure PostgreSQL 8.0.15
2. Open Planner from command line
3. Try to save to your data in database


Actual results:
We get this error on command line:
(planner:9567): Planner-WARNING **: SET TIME ZONE command failed: ERROR:  unrecognized time zone name: "utc"
The database is untouched.

Expected results:
No error, data being written into database.

Does this happen every time?
Yes

Other information:
Comment 1 Not Used 2009-02-15 04:01:47 UTC
Created attachment 128748 [details] [review]
Use 'UTC' everywhere so PostgreSQL stops complaining.
Comment 2 Maurice van der Pot 2009-04-14 17:27:42 UTC
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.