Re: date/time compatible problems in 7.2 - Mailing list pgsql-hackers

From Ruslan A Dautkhanov
Subject Re: date/time compatible problems in 7.2
Date
Msg-id 3C75B47D.167B5E15@scn.ru
Whole thread Raw
In response to date/time compatible problems in 7.2  (Ruslan A Dautkhanov <rusland@scn.ru>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "soetebeer.com"
Date:
Subject: Problems with the lower() and upper() functions and umlaut chars in 7.2
Next
From: peter@helpnet_BUT_NOT_SPAM.com.au
Date:
Subject: Re: SET NULL / SET NOT NULL