http://www.slony.info/bugzilla/show_bug.cgi?id=118

           Summary: initial copy of an inherited table can leave the table
                    empty
           Product: Slony-I
           Version: 2.0
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


This issue was discussed
http://lists.slony.info/pipermail/slony1-general/2010-March/010452.html and 
http://lists.slony.info/pipermail/slony1-general/2009-October/010076.html

If you have a table master

CREATE TABLE master(id serial, PRIMARY KEY (id));

and a second table that inherits from it

create table sub1 (
) inherits (master);
alter table sub1 add primary key(id);

Then if you add them to a replication set where sub1 has a lower slony table id
than master.

Ie 
set add table (id=1, set id=1, origin=1, fully qualified name = 'public.sub1',
comment='sub table 1');\n"
set add table (id=4, set id=1, origin=1, fully qualified name =
'public.master', comment='master table');\n"

on subscription we will have 

TRUNCATE sub
COPY sub1
TRUNCATE master;
COPY master;

When using postgrsql 8.4 this seems to leave us with no data in the table on
the subscriber.  This works fine with 8.3.  The regression test 'testinherit'
seems to produce this issue.

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.