[Bucardo-general] bucardo fails to replicate when the column name contains german umlauts
Christian Ritter
lnxlists at lownoize.org
Mon Sep 2 13:06:35 UTC 2013
On 2013-09-02 14:34, Michelle Sullivan wrote:
> Christian Ritter wrote:
>>
>> bucardo version is 4.5.0 <-got that from bucardo_ctl
>>
>> -- Schema for the main Bucardo database
>> -- Version 4.5.0
>>
>> The logs are from postgres, and there is no copy in the logs, only 2
>> inserts
>>
>
> Good... That should make things easier....
>
> What do you get when you do:
>
> SELECT DISTINCT d.rowid AS "BUCARDO_ID",
> t.id ,host_ip,"prüfsumme"
> FROM bucardo.bucardo_delta d
> LEFT JOIN public.testtable t ON (t.id::int4 =
> d.rowid::int4)
> WHERE d.tablename = 28039::oid
> AND NOT EXISTS (
> SELECT 1
> FROM bucardo.bucardo_track
> bt
> WHERE d.txntime = bt.txntime
> AND bt.targetdb =
> 'testb'::text
> AND bt.tablename =
> 28039::oid
> );
>
> on the source (should be one row) and:
>
>
> SELECT DISTINCT d.rowid AS "BUCARDO_ID",
> t.id ,host_ip,"prüfsumme"
> FROM bucardo.bucardo_delta d
> LEFT JOIN public.testtable t ON (t.id::int4 =
> d.rowid::int4)
> WHERE d.tablename = 28047::oid
> AND NOT EXISTS (
> SELECT 1
> FROM bucardo.bucardo_track
> bt
> WHERE d.txntime = bt.txntime
> AND bt.targetdb =
> 'testa'::text
> AND bt.tablename =
> 28047::oid
> );
>
> On the target (should be no rows)?
>
> Then what do you get when you do:
>
> SELECT id::text AS id FROM public.testtable WHERE (id) IN (1);
>
> on the source?
>
> Also what OS and PostgreSQL version are you using?
>
> Michelle
source:
BUCARDO_ID | id | host_ip | prüfsumme
------------+----+-------------+-----------
1 | 1 | 192.168.1.1 | foobar
(1 row)
target:
BUCARDO_ID | id | host_ip | prüfsumme
------------+----+---------+-----------
(0 rows)
source:
testa=# SELECT id::text AS id FROM public.testtable WHERE (id) IN (1);
id
----
1
(1 row)
OS is Ubuntu 12.04 and Postgres is Version 9.1.9, but was the same on
Slackware 14 and Postgres 9.2.1
Cheers
Christian
More information about the Bucardo-general
mailing list