<div dir="ltr"><div class="gmail_quote">On Wed, Dec 29, 2010 at 11:12 PM, lakshmi priya <span dir="ltr"><<a href="mailto:gangulynj@gmail.com">gangulynj@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
hi Gurjeet singh,<br> 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.<br>
<br>please clear my doubt its urgent.<br></blockquote><div><br>i) Slony replicates rows, and not individual fields.<br>ii) Slony cannot do selective replication; it will replicate all rows in a table.<br><br>So you might want create a separate table for status=1 rows, and maintain it using a trigger and then replicate that table.<br>
</div></div><br>Regards,<br>-- <br>gurjeet.singh<br>@ EnterpriseDB - The Enterprise Postgres Company<br><a href="http://www.EnterpriseDB.com">http://www.EnterpriseDB.com</a><br><br>singh.gurjeet@{ gmail | yahoo }.com<br>
Twitter/Skype: singh_gurjeet<br>
<br>Mail sent from my BlackLaptop device<br>
</div>