Search Postgresql Archives

Timestamp with time zone 'negative' problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

I have a DB in which items which are 'always valid' have a from_date of
19000101 000000+1 (Europe/Berlin)
When i try to restore the same DB to (Europe/Bucharest), instead of
19000101 000000+2, the timestamp becomes "1900-01-01 00:44:24+01:44:24"
which is ... strange. 
My software then complains (...correctly) that 01:44:24 is not a valid
timezone. 

Am i doing something wrong, or should i report this to pg-bugs?
Is there any way i can avoid this issue other than setting Timezone for
the DB to (Europe/Berlin)? I am considering UPDATE on the rows to 1901
or some such... but that's a very gimmicky solution.


Thank you,
Andrei Prodan
--------------------------------------------------
Awinta Consulting S.R.L.
Canaluluistr. 44
505600 Sacele
Brasov, Romania
Tel. +40368 / 441024
Fax. +40368 / 441024
--------------------------------------------------



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux