Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Fri, Dec 15, 2006 at 11:37:56AM -0500, Tom Lane wrote: Joachim Wieland [EMAIL PROTECTED] writes: Appended is a patch that adds JST and JDT into Asia.txt and the Default set. Um ... is there a JDT? Last I heard, Japan does not observe daylight time. I don't see a JDT in the old PG set of

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Tom Lane
Joachim Wieland [EMAIL PROTECTED] writes: True... Actually I wonder how I have to read the zic files in this case. It says: Rule Japan 1948only- May Sun=1 2:001:00D Rule Japan 19481951- Sep Sat=8 2:000 S Rule Japan 1949only

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Sat, Dec 16, 2006 at 10:26:52AM -0500, Tom Lane wrote: Joachim Wieland [EMAIL PROTECTED] writes: True... Actually I wonder how I have to read the zic files in this case. It says: RuleJapan 1948only- May Sun=1 2:001:00 D RuleJapan 1948

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Brian Hurt
Joachim Wieland wrote: Yes, I completely agree that JDT should not be included. I just wanted to understand how those lines show that JST is still in active use. As far as I understand it, it says that JST was observed from 1948 to 1951 (the second rule) and now there is a time zone J%sT

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-16 Thread Joachim Wieland
On Sat, Dec 16, 2006 at 12:52:12PM -0500, Brian Hurt wrote: Joachim Wieland wrote: Yes, I completely agree that JDT should not be included. I just wanted to understand how those lines show that JST is still in active use. As far as I understand it, it says that JST was observed from 1948 to

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Martijn van Oosterhout
On Fri, Dec 15, 2006 at 03:48:50PM +0900, Hiroshi Saito wrote: Hi. I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? The list of accepted timezones is now configurable, check through the docs how

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Hiroshi Saito
- Original Message - From: Martijn van Oosterhout I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? The list of accepted timezones is now configurable, check through the docs how to find the

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Martijn van Oosterhout
On Fri, Dec 15, 2006 at 08:20:22PM +0900, Hiroshi Saito wrote: Thanks. I do not think that this is normal. As for 8.2.. SELECT timeofday()::timestamp; ERROR: invalid input syntax for type timestamp: Fri Dec 15 14:26:05.502000 2006 JST Err, sounds like a bug to me. Good ahead and

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Tom Lane
Martijn van Oosterhout kleptog@svana.org writes: On Fri, Dec 15, 2006 at 03:48:50PM +0900, Hiroshi Saito wrote: I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? The list of accepted timezones is

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Christopher Browne
Tom Lane [EMAIL PROTECTED] writes: Martijn van Oosterhout kleptog@svana.org writes: On Fri, Dec 15, 2006 at 03:48:50PM +0900, Hiroshi Saito wrote: I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem?

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Christopher Browne
Hiroshi Saito [EMAIL PROTECTED] writes: Hi. I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? Ver 8.1.5 saito=# select 'Fri Dec 15 14:26:05.502000 2006 JST'::timestamp; timestamp

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Joachim Wieland
On Fri, Dec 15, 2006 at 10:17:20AM -0500, Tom Lane wrote: However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? The list of accepted timezones is now configurable, check through the docs how to find the list and set it the way you want. Yeah, but why the

Re: [HACKERS] invalid input syntax for type timestamp.

2006-12-15 Thread Tom Lane
Joachim Wieland [EMAIL PROTECTED] writes: Appended is a patch that adds JST and JDT into Asia.txt and the Default set. Um ... is there a JDT? Last I heard, Japan does not observe daylight time. I don't see a JDT in the old PG set of recognized zone names, and I'd think we'd have heard

[HACKERS] invalid input syntax for type timestamp.

2006-12-14 Thread Hiroshi Saito
Hi. I was doing the field test of Slony-I 1.2.2 release now. However, I encounter the problem of timestamp.:-( Was anyone recognizing this problem? Ver 8.1.5 saito=# select 'Fri Dec 15 14:26:05.502000 2006 JST'::timestamp; timestamp - 2006-12-15 14:26:05.502 Ver