Re: invalid input syntax for type timestamp.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joachim Wieland <joe(at)mcknight(dot)de>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>, pgsql-hackers(at)postgresql(dot)org, Devrim GUNDUZ <devrim(at)commandprompt(dot)com>, Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
Subject: Re: invalid input syntax for type timestamp.
Date: 2006-12-16 15:26:52
Message-ID: 29124.1166282812@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joachim Wieland <joe(at)mcknight(dot)de> writes:
> True... Actually I wonder how I have to read the zic files in this case.
> It says:

> Rule Japan 1948 only - May Sun>=1 2:00 1:00 D
> Rule Japan 1948 1951 - Sep Sat>=8 2:00 0 S
> Rule Japan 1949 only - Apr Sun>=1 2:00 1:00 D
> Rule Japan 1950 1951 - May Sun>=1 2:00 1:00 D

> Zone Asia/Tokyo 9:18:59 - LMT 1887 Dec 31 15:00u
> 9:00 - JST 1896
> 9:00 - CJT 1938
> 9:00 Japan J%sT

It looks to me like this says that the only time Japan ever observed DST
was during the American occupation immediately after WWII. I can well
imagine that they'll never adopt it on their own given that history.

Anyway, given the lack of complaints about our pre-8.2 behavior, it
seems clear that "JDT" is not an abbreviation in use now, so I'm content
to leave it out of the files. Anybody working with historical info can
always add it for themselves.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-12-16 15:38:40 Re: [HACKERS] psql commandline conninfo
Previous Message ohp 2006-12-16 15:00:13 Re: unixware and --with-ldap