> ecommerce=# SELECT COUNT(DISTINCT target) FROM > bucardo.bucardo_delta_targets WHERE tablename::regclass::text = > 'saved_cart'; > count > ------- > 1
This simplifies things a lot. From here, you should be able to see why rows are not being removed from the delta table. They should be removed if there is a matching (by txntime) entry in the target table. Note that there must be exactly one - not zero, not two. :) So focus on a single row from the delta table and make sure it meets all the criteria for deletion. -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
