On Wed, Dec 29, 2010 at 11:12 PM, lakshmi priya <gangulynj at gmail.com> wrote:

> hi Gurjeet singh,
>        I have created two database,and replications takes place.In my first
> database there is a table called node.In that table i have created a status
> field..now i have check the condition for my status field if my status = 1
> my values have to replicate in slave table els status =0  then my field
> shouldnot replicate in my slave.
>
> please clear my doubt its urgent.
>

i) Slony replicates rows, and not individual fields.
ii) Slony cannot do selective replication; it will replicate all rows in a
table.

So you might want create a separate table for status=1 rows, and maintain it
using a trigger and then replicate that table.

Regards,
-- 
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.EnterpriseDB.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20101229/ac52c966/attachment.htm