[Bucardo-general] Why does bucardo consider non-primary keys?

Jost Boekemeier jost.boekemeier at googlemail.com
Mon Jun 27 20:15:07 UTC 2011


Hi,

given the table

CREATE TABLE public.t1 ( id serial NOT NULL,  pt point, CONSTRAINT
t1_pk PRIMARY KEY (id))

bucardo currently creates the following statement:

SELECT  DISTINCT  d.rowid AS "BUCARDO_ID", t.id ,pt AS pt FROM ...

which doesn't work, of course. Shouldn't this be:

SELECT  DISTINCT ON (d.rowid, t.id)  d.rowid AS "BUCARDO_ID", t.id ,pt
AS pt FROM ...


I can prepare a patch if you want me to.


Regards,
Jost Bökemeier


More information about the Bucardo-general mailing list