Merge lp:~stefanor/ibid/pg-tz-417184 into lp:~ibid-core/ibid/old-trunk-pack-0.92

[Stefano Rivera]

[Michael Gorven (mgorven)]

Wow, databases suck.
 review approve

review: Approve

[Jonathan Hitchcock (vhata)]

What he said.

review: Approve

=== modified file 'ibid/core.py'
--- ibid/core.py	2009-07-15 22:28:01 +0000
+++ ibid/core.py	2009-08-29 21:22:27 +0000
@@ -305,11 +305,19 @@
                         c.execute("SET storage_engine=%s;" % mysql_engine)
                         c.execute("SET time_zone='+0:00';")
                         c.close()
-
                 engine.pool.add_listener(MySQLModeListener())
 
                 engine.dialect.use_ansiquotes = True
 
+            elif uri.startswith('postgres://'):
+                class PGSQLModeListener(object):
+                    def connect(self, dbapi_con, con_record):
+                        c = dbapi_con.cursor()
+                        c.execute("SET TIME ZONE UTC")
+                        c.close()
+
+                engine.pool.add_listener(PGSQLModeListener())
+
         self[name] = scoped_session(sessionmaker(bind=engine))
 
         self.log.info(u"Loaded %s database", name)