That's really odd. Are Perl strings not 8-bit clean by default? I
wouldn't have thought...
On 09/02/2013 04:33 AM, Christian Ritter wrote:
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
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
United States
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
