id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
1823	set timezone in pgsql is not working right	w4kpm@…	Adrian Holovaty	"set timezone command for postgres is currently ""set time zone . . ."" which crashes.

should be ""set timezone to""

{{{
===================================================================
--- django/db/backends/postgresql/base.py       (revision 2868)
+++ django/db/backends/postgresql/base.py       (working copy)
@@ -39,7 +39,7 @@
             self.connection = Database.connect(conn_string)
             self.connection.set_isolation_level(1) # make transactions transparent to all cursors
         cursor = self.connection.cursor()
-        cursor.execute(""SET TIME ZONE %s"", [settings.TIME_ZONE])
+        cursor.execute(""SET TIMEZONE %s"", [settings.TIME_ZONE])
         if settings.DEBUG:
             return util.CursorDebugWrapper(cursor, self)
         return cursor
}}}

Thanks,
Kelly"	defect	closed	contrib.admin	dev	normal	invalid			Unreviewed	0	0	0	0	0	0