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

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" (beca

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 > > RuleJ

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 1949

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

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 compla

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, b

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; >timesta

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

2006-12-15 Thread Christopher Browne
Tom Lane <[EMAIL PROTECTED]> writes: > Martijn van Oosterhout 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? > >> T

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

2006-12-15 Thread Tom Lane
Martijn van Oosterhout 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 now configur

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

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 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 h

[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 8