| From: | "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "Devrim GUNDUZ" <devrim(at)commandprompt(dot)com>, "Christopher Browne" <cbbrowne(at)ca(dot)afilias(dot)info> |
| Subject: | invalid input syntax for type timestamp. |
| Date: | 2006-12-15 06:48:50 |
| Message-ID: | 05b801c72015$13f7afb0$3043040a@wiseknot.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.2.0
saito=# select 'Fri Dec 15 14:26:05.502000 2006 JST'::timestamp;
ERROR: invalid input syntax for type timestamp: "Fri Dec 15 14:26:05.502000 2006 JST"
saito=# select 'Fri Dec 15 14:26:05.502000 2006 GMT'::timestamp;
timestamp
-------------------------
2006-12-15 14:26:05.502
Umm, I might refrain from release for 8.2 of Slony-I for this problem.
Regards,
Hiroshi Saito
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2006-12-15 08:54:13 | Re: unixware and --with-ldap |
| Previous Message | Tom Lane | 2006-12-15 01:31:59 | Re: Operator class group proposal |