I am having a problem where the initial copy of data into a "slave" table seems to be getting lost. I have a table called "schema", and our application database gets installed with 2 records in this table. I see the copy happening in the log, but when I look at the slave table after the subscription is done, it's empty.

I have a couple of other pre-populated tables like this, but they are not exhibiting the same behavior. The difference is that the "schema" table has FK constraints pointing at it, and the other tables do not. At the point when I am configuring replication, none of the tables with FKs pointing to "schema" table have any data in them, and I have further verified that these constraints are defined "NO ACTION" on delete/update. 

I have included what I think are the relevant portions of the slony log and the server log (-d 5). The server log shows the "analyze" done by slon showing 2 records, which is what I expect to see. I've looked elsewhere in the server log and don't see evidence (a constraint cascade or something) of a subsequent delete happening on the table.

Any ideas for further places to look would be a great help.


slon log:
====================================================================================================
DEBUG2 remoteWorkerThread_1: copy table public.schema
DEBUG3 remoteWorkerThread_1: table public.schema does not require Slony-I serial key
DEBUG2 remoteWorkerThread_1: 218 bytes copied for table public.schema
DEBUG2 remoteWorkerThread_1: 0.471 seconds to copy table public.schema
====================================================================================================

server log:
====================================================================================================
DEBUG:  StartTransactionCommand
LOG:  statement: delete from public.schema; copy public.schema from stdin; 
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 4 :querySource 0 :canSetTag true :utilityStmt <>
	:resultRelation 1 :into <> :hasAggs false :hasSubLinks false :rtable ({RTE
	:alias <> :eref {ALIAS :aliasname schema :colnames ("dbid" "tuid"
	"foundryversion" "name" "description" "objecttype" "generic" "state" "visible"
	"schematype" "namespace" "content")} :rtekind 0 :relid 17626 :inh true
	:inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0})
	:jointree {FROMEXPR :fromlist ({RANGETBLREF :rtindex 1}) :quals <>} :rowMarks
	() :targetList <> :groupClause <> :havingQual <> :distinctClause <>
	:sortClause <> :limitOffset <> :limitCount <> :setOperations <>
	:resultRelations ()}
	
DEBUG:  rewritten parse tree:
DETAIL:  ({QUERY :commandType 4 :querySource 0 :canSetTag true :utilityStmt <>
	:resultRelation 1 :into <> :hasAggs false :hasSubLinks false :rtable ({RTE
	:alias <> :eref {ALIAS :aliasname schema :colnames ("dbid" "tuid"
	"foundryversion" "name" "description" "objecttype" "generic" "state" "visible"
	"schematype" "namespace" "content")} :rtekind 0 :relid 17626 :inh true
	:inFromCl false :checkForRead false :checkForWrite true :checkAsUser 0})
	:jointree {FROMEXPR :fromlist ({RANGETBLREF :rtindex 1}) :quals <>} :rowMarks
	() :targetList <> :groupClause <> :havingQual <> :distinctClause <>
	:sortClause <> :limitOffset <> :limitCount <> :setOperations <>
	:resultRelations ()})
	
DEBUG:  plan:
DETAIL:  {SEQSCAN :startup_cost 0.00 :total_cost 1.02 :plan_rows 2 :plan_width 6
	:targetlist ({TARGETENTRY :resdom {RESDOM :resno 1 :restype 27 :restypmod -1
	:resname ctid :ressortgroupref 0 :resorigtbl 0 :resorigcol 0 :resjunk true}
	:expr {VAR :varno 1 :varattno -1 :vartype 27 :vartypmod -1 :varlevelsup 0
	:varnoold 1 :varoattno -1}}) :qual <> :lefttree <> :righttree <> :initPlan <>
	:extParam () :allParam () :nParamExec 0 :scanrelid 1}
	
DEBUG:  ProcessQuery
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
	:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
	:jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <>
	:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
	:setOperations <> :resultRelations ()}
	
DEBUG:  rewritten parse tree:
DETAIL:  ({QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
	:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
	:jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <>
	:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
	:setOperations <> :resultRelations ()})
	
DEBUG:  ProcessUtility
DEBUG:  find_in_dynamic_libpath: trying "/home/dparker/install/ed9i04/tazz/postgresql/lib/slony1_funcs"
CONTEXT:  COPY schema, line 1: "1	THISISTHEMOTHEROFALLSCHEMASRIGHT	1.0	XSD	Fake schema representing the xsd: schema	schema	f	\N	t	\N..."
DEBUG:  find_in_dynamic_libpath: trying "/home/dparker/install/ed9i04/tazz/lib/slony1_funcs"
CONTEXT:  COPY schema, line 1: "1	THISISTHEMOTHEROFALLSCHEMASRIGHT	1.0	XSD	Fake schema representing the xsd: schema	schema	f	\N	t	\N..."
DEBUG:  find_in_dynamic_libpath: trying "/home/dparker/install/ed9i04/tazz/postgresql/lib/slony1_funcs.so"
CONTEXT:  COPY schema, line 1: "1	THISISTHEMOTHEROFALLSCHEMASRIGHT	1.0	XSD	Fake schema representing the xsd: schema	schema	f	\N	t	\N..."
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
LOG:  statement: analyze public.schema; 
DEBUG:  parse tree:
DETAIL:  {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
	:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
	:jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <>
	:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
	:setOperations <> :resultRelations ()}
	
DEBUG:  rewritten parse tree:
DETAIL:  ({QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
	:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
	:jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <>
	:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
	:setOperations <> :resultRelations ()})
	
DEBUG:  ProcessUtility
DEBUG:  analyzing "public.schema"
DEBUG:  "schema": 1 pages, 2 rows sampled, 2 estimated total rows
DEBUG:  CommitTransactionCommand
====================================================================================================


- DAP
----------------------------------------------------------------------------------
David Parker    Tazz Networks    (401) 709-5130
?