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

[Michelle Sullivan]

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

-- 
Michelle Sullivan
http://www.mhix.org/