[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