[Bucardo-general] bucardo fails to replicate when the column name contains german umlauts
Christian Ritter
lnxlists at lownoize.org
Mon Sep 2 08:33:28 UTC 2013
Hello,
i have a really strange problem with bucardo and german umlauts.
If you have a table where a column name contains german umlauts bucardo
is unable to replicate the data.
Bucardo version is 4.5.0 and postgres version is 9.1.9 or 9.2.1
If you create a table like that on both databases:
CREATE TABLE testtable
(
id integer primary key,
host_ip inet NOT NULL,
prüfsumme character varying(255) NOT NULL
);
and then add some data to that table, like:
INSERT INTO testtable VALUES (1, '192.168.1.1', 'foobar');
bucardo fails to replicate it and you get an error:
KID [1/1] public.testtable INSERT source to target pk 1
KID Warning! Aborting due to exception for public.testtable.id: 1 Error
was DBD::Pg::st execute failed: ERROR: null value in column "prüfsumme"
violates not-null constraint at /root/perl5/lib/perl5/Bucardo.pm line
5769.
KID Final database backend PID is 10758
It looks like bucardo tries to insert NULL and not foobar into the
column called "prüfsumme" which of course breaks the NOT NULL
constraint.
complete log of db creation and bucardo install is here:
http://pastebin.com/Q8KV06jA
log.bucardo could be found here:
http://pastebin.com/TyCbn8mz
Cheers
Christian
More information about the Bucardo-general
mailing list