Scott Marlowe scott.marlowe at gmail.com
Wed Dec 17 20:35:16 PST 2014
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.


More information about the Slony1-general mailing list