[Bucardo-general] bucardo fails to replicate when the column name contains german umlauts

Greg Sabino Mullane greg at endpoint.com
Wed Sep 4 01:24:20 UTC 2013


On Tue, Sep 03, 2013 at 09:00:57AM +0200, Christian Ritter wrote:
>     "pr\x{fc}fsumme" => 'foobar',
>     'id' => 2,
>     'host_ip' => '192.168.1.2'
>   }
> };
> $BUCARDO1 = [
>   'host_ip',
>   'pr??fsumme'

Yep, there is the mismatch. On my box (US-centric, with UTF-8 databases), 
both appear with the slash-x version. Why your second one is different 
from the first, I am not sure. Can you check the server encodings on the 
databases used in replication, as well as the bucardo database itself? 
I'm wondering if this isn't perhaps a bug in DBD::Pg. One of the column 
names comes from a direct querying of pg_attribute, and thus is a simple 
result. The other comes from hashall_arrayref. I will ponder this some more.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130903/42cf4106/attachment.sig>


More information about the Bucardo-general mailing list