From: | "Prodan, Andrei" <Andrei(dot)Prodan(at)awinta(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Timestamp with time zone 'negative' problem |
Date: | 2012-01-20 10:09:09 |
Message-ID: | D33393149C01874DB3D72FE46A1B268B72C0A1@vpmail05-x.intra.ads-root.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
--------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2012-01-20 10:53:39 | Numerous prepared transactions? |
Previous Message | John R Pierce | 2012-01-20 08:32:58 | Re: dblink (INSERT ..... RETURNING) |