Use BaseTzInfo as base class for all objects

[Peter Bex]

I'm trying to use pytz objects in combination with psycopg2. In order to automatically convert objects in query parameters, one can register a so called adapter.

Psycopg2 detects which type something is from its class, and uses isinstance to match it up with the registered adapter for that type.

I tried registering an adapter for pytz.tzinfo.BaseTzInfo, but then immediately noticed that pytz.UTC is not a subclass of BaseTzInfo, but only of datetime.tzinfo. This poses a problem, because while all the things returned by pytz.timezone() have a "zone" attribute for retrieving the name of the timezone, datetime.tzinfo has no documented way of doing the same.

To avoid this, I now have to register both an adapter for type(pytz.UTC) (because it's a singleton and not a class, I have to use type()) _and_ for pytz.tzinfo.BaseTzInfo.

For information on adapting type in psycopg2, see http://pythonhosted.org/psycopg2/advanced.html#adapting-new-types

[Stuart Bishop (stub)]

A common base class is certainly possible, and BaseTzInfo is likely the best candidate.

[Jens Troeger (jens.troeger)]

@Stuart, any idea when this bug might be addressed?