GNOME Bugzilla – Bug 571801
SET TIMEZONE UTC should read SET TIMEZONE 'UTC'
Last modified: 2009-04-14 17:27:42 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:
Created attachment 128748 [details] [review] Use 'UTC' everywhere so PostgreSQL stops complaining.
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.