Re: date/time compatible problems in 7.2

Hi Thomas,

>
> > > Not sure why it is crashing. But "KRAT" is a time zone not recognized by
> > > the PostgreSQL date/time parser. In fact it could be afaik (it is
> > > mentioned but commented-out in the parser) but it either had a screwy
> > > definition or I couldn't figure out what the definition was. It could be
> > > added for 7.2.1 (and I could send a patch beforehand) if I knew the
> > > proper definition. Check src/backend/utils/adt/datetime.c and look for
> > > "krat".
> > KRAT,KRAST is timezone code generated by FreeBSD automatically.
> > You can check up /usr/share/zoneinfo - it have all timezones.
> > You can see timezones KRAT,KRAST in file
> > /usr/share/zoneinfo/Asia/Krasnoyarsk.
>
> Nope. You will have to *please* give me more details. On my Linux
> (Mandrake) systems the zoneinfo data is included in the glibc package,
> and the Asia/Krasnoyarsk entries refer to "Krasnoyarsk" not to "KRAT" or
> any other abbreviation. They also seem to be empty of any other useful
> information. I'm not sure where I got the original reference to "krat"
> to include as a placeholder in the code.

Check out, please http://www.weltzeituhr.com/laender/zeitzonen_e.shtml.
KRAT figurate in this list as Krasnoyarsk time, and KRAST as Krasnoyarsk
Summertime.

You can try also http://www.worldtimezone.com/wtz-names/timezonenames.html
or http://www.htmlcompendium.org/reference-notes/7timzone.htm
or (binary zoneinfo files)
http://lrp1.steinkuehler.net/files/kernels/zoneinfo/ .

Thanks,
Ruslan A Dautkhanov