Hello.

Suppose I perform the query on a Master:

UPDATE tbl SET tbl_id=3Dtbl_id WHERE tbl_id=3D123;

Its purpose is just to all all associated triggers for the row 123 in tbl.
Then I watch sl_log_1 and see the following event in it:

log_cmddata=3D"tbl_id=3D123 WHERE tbl_id=3D123"

The question is: why? Slaves do not need to perform this query at all, but
it is propagated to them.

I suppose that Slony generates log_cmddata comparing OLD and NEW
field-by-field and then - insert only differences to log_cmddata. (If it is
not true, and Slony performs a different algorythm, please detalize.) But,
if there is no differences between OLD and NEW (as in above sample), no need
to generate an event at all...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070704/=
a5625036/attachment.htm