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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match