Hi

Here is an attempt at integrating my algorithm into slony1.
I tried it on one of the nodes of my slony cluster, and
it seems to generate correct listen entries, but haven't
tested anything else yet.

The thing I'm most unsure about is if the logic regarding
set-subscriptions is correct. At the moment, I ignore
a possible sl_listen entry if there is a subscription
with set-origin = li_origin, set-subscriber = li_receiver
and set-provider != li_provider. Are there any other
special cases to watch out for?

The attached file contains two functions - A replacement
fro RebuildListenEntries, and a helper calles
ReachableFromNode.

greetings, Florian Pflug
-------------- next part --------------
A non-text attachment was scrubbed...
Name: slony1_funcs.listenentries.test.sql
Type: application/octet-stream
Size: 3343 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060303/e02a5087/slony1_funcs.listenentries.test-0001.obj