So as the title states, we're running pg 9.2.9 and slony 2.2.1 If you create a parent / child table with inherit, then truncate only the parent table, it will work properly on the source but will propagate as a regular truncate on the destinations.
create table parent yada; create table chlid inherits parent yada; insert rows into parent, and rows into child tables subscribe parent and child to another node... on source run "truncate only parent" and note that child table there still has its own rows. Check on subscriber and children tables are now empty. 1: Is this a known bug? 2: Is it planned to fix it? We were bitten by it quite by surprise and lost a lot of data in child tables. Luckily we noticed before switching over from the master node to another and resubed the child tables. -- To understand recursion, one must first understand recursion. _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
