[Bucardo-general] Failed on make test on Bucardo 3.1.0 and a question about timeofday() usage
yan farmawan
100.persen.linux at gmail.com
Wed Feb 11 02:29:20 UTC 2009
First of all, I would like to thanks Mr. Greg Salbino for creating and
releasing Bucardo,
as it is just what I need.
I'm testing bucardo git version 3.1.0. with postgresql 8.3.3 and perl 5.10.0
Unfortunately I failed on 'make test'. Mostly on these lines:
(note: xxxx is the name of all test script)
Subroutine main::like redefined at t/xxxx line 14
Subroutine main::pass redefined at t/xxxx line 14y
Subroutine main::isa_ok redefined at t/xxxx line 14
Subroutine main::ok redefined at t/xxx line 14
Subroutine main::is_deeply redefined at t/xxx line 14
Anyway I move on.. and have succeeded to sync with pushdelta on a table.
But ..... with some changes on Bucardo.pm, because I got these errors
with the original Bucardo.pm :
(3277) [1234274461] CTL Warning! Controller for "goodguy_syn" was
killed at line 2660: DBD::Pg::db do failed: ERROR: invalid input
syntax for type timestamp: "Tue Feb 10 21:01:01.724052 2009 WIT" at
/opt/perl/lib/site_perl/5.10.0/Bucardo.pm line 2660.
At last, Bucardo managed to sync after all occurences of:
timeofday()::timestamp is changed to current_timestamp
timeofday()::timestamptz is changed to current_timestamp::timestamptz
Why using timeofday() ? As per-postgresql doc, timeofday() returns
text. Why not use now(), or current_timestamp, or
statement_timestamp() since all these funcs already returns timestamp
or timestamptz ?
Note: I'm using lc_time = 'en_US.UTF-8' ... if it is matter.
I would like to test latest bucardo with as similar as to your
environments (postgresql version, perl version, postgresql.conf) . How
could I do that ?
Best regards and thank you.
More information about the Bucardo-general
mailing list