Psycopg2: Incorrect psycopg2.tz.FixedOffsetTimezone after pickling datetimes with different timezones

Created on 21 Oct 2012 · 4Comments · Source: psycopg/psycopg2

Originally submitted by: Psycopg website

Submitted by: Robert Saint

>>> before_pickling = []
>>> cur.execute("SET TIME ZONE 'Europe/Rome';")  # UTC + 1 hour
>>> cur.execute("SELECT '2010-01-01 10:30:45'::timestamptz;")
>>> before_pickling.append(cur.fetchone()[0])
>>> cur.execute("SET TIME ZONE 'Europe/Moscow';")  # UTC + 3 hour
>>> cur.execute("SELECT '2010-01-01 10:30:45'::timestamptz;")
>>> before_pickling.append(cur.fetchone()[0])
>>> print before_pickling
[datetime.datetime(2010, 1, 1, 10, 30, 45, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None)), 
    datetime.datetime(2010, 1, 1, 10, 30, 45, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=180, name=None))]
>>> after_pickling = pickle.loads(pickle.dumps(before_pickling))
>>> print before_pickling == after_pickling
False
>>> print after_pickling
[datetime.datetime(2010, 1, 1, 10, 30, 45, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=180, name=None)), 
    datetime.datetime(2010, 1, 1, 10, 30, 45, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=180, name=None))]

Source

psycoteam

All 4 comments

What the... Confirmed.

dvarrazzo on 21 Oct 2012

Minimal test:

In [1]: import psycopg2.tz

In [2]: import pickle

In [3]: pickle.loads(pickle.dumps([psycopg2.tz.FixedOffsetTimezone(offset=60), 
    psycopg2.tz.FixedOffsetTimezone(offset=180)]))
Out[3]: 
[psycopg2.tz.FixedOffsetTimezone(offset=180, name=None),
 psycopg2.tz.FixedOffsetTimezone(offset=180, name=None)]

dvarrazzo on 21 Oct 2012

Fixed in my devel and 2.4 maint branch

dvarrazzo on 21 Oct 2012

Originally submitted by: ecigarette2012

Dreambox DM800 HD PVR
dm800
800hd
dreambox dm800hd
dm 800 hd
dm 800 hd pvr
dreambox hd
dreambox 800 hd
dm 800
dreambox dm 800 hd pvr
dreambox dm 800 hd
dreambox 800
dm800hd
dreambox dm800
dm800 hd pvr
Dreambox DM800C