cast_type of DateTimePGPSymmetricKeyField does not allow for dumpdata exports exporting timezone aware datetimes.

[steezeburger]

Extremely easy to override with a custom class when using Postgres as your database

class CustomDateTimePGPSymmetricKeyField(fields.DateTimePGPSymmetricKeyField):
    """
    Overriding cast_type so `dumpdata` command exports timezone aware datetimes.
    """
    cast_type = 'TIMESTAMPTZ'

but maybe this could be a setting? Or it could look at current USE_TZ setting?

[peterfarrell]

@steezeburger

Django treats all datetimes with timezone so this likely a bug by using the wrong cast type. Ref:

https://docs.djangoproject.com/en/3.1/topics/i18n/timezones/#postgresql

I think we can safely change over to TIMESTAMPTZ without any ill effects given that is what Django always uses. A PR is welcome to fix this.

[steezeburger]

Ah beat me to it! I forgot I forked this and fixed, but never got the tests running and forgot to submit the PR haha. Thanks for this!

[peterfarrell]

@steezeburger still need to do a release -- install from master if you want it today.