Thread: CEST timezone

Is it a bug or CEST timezone is not supported anymore ?
I can't import my 7.1.2 database to current development version of
postgresql


lis=# create table test (ts timestamp);
CREATE
lis=# insert into test values ('23.05.2000 09:06:59.00 CEST');
ERROR:  Bad timestamp external representation '23.05.2000 09:06:59.00
CEST'
lis=# insert into test values ('23.05.2000 09:06:59.00 CET');
INSERT 125614 1
lis=# select * from test;           ts
--------------------------23.05.2000 10:06:59 CEST
(1 row)
lis=# select version();                           version
----------------------------------------------------------------PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by
GCC2.96
 
(1 row)

lis=#


Jan Varga

> Is it a bug or CEST timezone is not supported anymore ?
> I can't import my 7.1.2 database to current development version of
> postgresql

afaik "CEST" was never supported by PostgreSQL. Can you please confirm
that this is the same as "CETDST" (Central European Time, Daylight
Savings Time) or, perhaps, "CET" (Central European Standard Time)? We
can add "CEST" as a synonym once I understand what it is supposed to be
;)

My guess is that your timezone database on your OS has changed; I've
looked back to versions from the beginning of 2000 and didn't see any
mention of CEST in the PostgreSQL code.
                   - Thomas

> Thanks for your reply.
> Yes, CEST equals to CETDST
> please add CEST as a synonym to existing timezone code (if it is possible)

Done in my sources; will be committed soon.
                     - Thomas