"Andrew And" <[EMAIL PROTECTED]> writes: > I have this problem that I show below but I don't know what I could > do. Could someone help me? > > > > <stdin>:4: PGRES_FATAL_ERROR select "_slave".subscribeSet(1, 1, 2, 'f'); > > - ERROR: insert or update on table "sl_path" violates foreign key constraint > "pa_client-no_id-ref" DETAIL: > > Key (pa_client)=(2) is not present in table "sl_node". CONTEXT: > > SQL statement "insert into "_slave".sl_path (pa_server, pa_client, > pa_conninfo, pa_connretry) values ( $1 , $2 , '<event pending>', 10)" > > PL/pgSQL function "subscribeset_int" line 53 at SQL statement SQL statement > "SELECT "_slave".subscribeSet_int( $1 , $2 , $3 , $4 )" > > PL/pgSQL function "subscribeset" line 63 at perform
Well, you cannot set up a subscription unless there is a direct path in sl_path from the provider to the subscriber. And a path can't exist unless the node is aware of both nodess. Evidently the node isn't even aware of the existence of node #2, so there's neither a suitable node nor a suitable path. Perhaps you haven't launched slon processes? -- (reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc")) <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
