Package: postgresql
Version: 7.4.7-6sarge1
When changing the time zone of a session, postgresql start to respond
with erronous date such as 1979-06-06 09:42:49.854158-227814:06.
Is there a hope that a fix will be included in the upcoming sarge
release? What can I do to fix the problem if not?
Below is the output of the following command on sarge:
SELECT NOW();
SET TIME ZONE INTERVAL '-05:00' HOUR TO MINUTE;
SELECT NOW();
--------------------------------------------------------------------
template1=# SELECT NOW();
now
-------------------------------
2005-06-01 11:49:45.097071-04
(1 row)
template1=# SET TIME ZONE INTERVAL '-05:00' HOUR TO MINUTE;
SET
template1=# SELECT NOW();
now
--------------------------------------
1979-06-06 09:42:49.854158-227814:06
(1 row)
--------------------------------------------------------------------
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
ii postgresql 7.4.7-6sarge1 object-relational SQL database management sy
ii postgresql-cli 7.4.7-6sarge1 front-end programs for PostgreSQL
ii postgresql-con 7.4.7-6sarge1 additional facilities for PostgreSQL
ii postgresql-doc 7.4.7-6sarge1 documentation for the PostgreSQL database ma
ii postgresql-plr 0.5.3+0.5.4alp Procedural language interface between Postgr
--
Guillaume Beaudoin À la hauteur de mon avenir.
Service Informatique Une tradition d'excellence
Collège de Bois-de-Boulogne depuis plus de 40 ans.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
