#30638: Allow the per-database TIME_ZONE option on databases that support
timezones.
-------------------------------------+-------------------------------------
Reporter: Aymeric Augustin | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Aymeric Augustin):
* status: closed => new
* resolution: needsinfo =>
Comment:
Let me try to explain again.
I'm reading data in a third-party PostgreSQL database where `timestamp`
columns contains values in UTC. I'm using non-managed models and the admin
to give users read-only access to this database. As far as I know, all
these things are legitimate things to do with Django.
Since my global TIME_ZONE setting is Europe/Paris (CET/UTC+1 or
CEST/UTC+2), if a row in this database contains a value that is 9am (UTC),
then the admin should show 11am (CEST). However, the admin shows 9am.
Since the admin doesn't show the correct values, users are confused. Since
Django doesn't give me a way to configure this, I'm frustrated.
----
I think that the following configuration would adequately reflect the
situation:
{{{
USE_TZ = True
DATABASES = {
...,
'other': {
...,
'TIME_ZONE': 'UTC',
},
}
}}}
Unfortunately, if I do this, Django throws an error, because of this check
which I wrote in ed83881e648:
{{{
def check_settings(self):
if self.settings_dict['TIME_ZONE'] is not None:
...
elif self.features.supports_timezones:
raise ImproperlyConfigured(
"Connection '%s' cannot set TIME_ZONE because its
engine "
"handles time zones conversions natively." %
self.alias)
}}}
I'm proposing to change Django so it will accept this configuration and
get the right values from the database and display them correctly in the
admin.
Essentially this requires two changes in the PostgreSQL backend:
- adding a database converter for datetimes
- updating the database adapter for datetimes
and, of course, removing the code that prevents this configuration.
--
Ticket URL: <https://code.djangoproject.com/ticket/30638#comment:5>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.dbfcc2e50c641ad3c81f5864e0388d71%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
