Mon Aug 16 23:13:13 PDT 2010
- Previous message: [Slony1-general] Update the column with same value
- Next message: [Slony1-general] Update the column with same value
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Triggers on the table may still need to fire; they certainly did, on the > origin, and they may also need to, on subscribers. > Mine might be a naive question however why do we need a query like below if both the old and new values are same in the UPDATE statement to be executed on slaves. UPDATE tbl set key='x' where key='x'. This unnecessarily causes additional table and index bloat on the subscribers. Thanks, Sivakumar.K -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100817/6eef3fa8/attachment.htm
- Previous message: [Slony1-general] Update the column with same value
- Next message: [Slony1-general] Update the column with same value
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list