[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