[Bucardo-general] update only replica
josh at endpoint.com
Mon Aug 31 17:52:22 UTC 2009
On Sat, Aug 29, 2009 at 11:30:06PM +1000, Grant Maxwell wrote:
> I would like to have a replication rule that for a specific sync rule or
> for a specific table, only replicates record updates. Inserts and Deletes
> are not replicated. Is there an easy way to achieve this ?
> The reason I want this is that for a specific (very key) table, records
> are created and then within a minute or so are either updated with final
> information or deleted.
> I only want finalised records transferred.
You might be able to achieve this with a customselect option, if there's some
way to look at a particular record and tell whether or not it has been
finalized. For instance, if there's a boolean field called is_final, you might
have your customselect statement say "SELECT ... FROM table WHERE is_final".
Josh Tolley josh at endpoint.com 801-485-0203
End Point Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090831/7f60b74a/attachment.bin
More information about the Bucardo-general