On Wed, Dec 29, 2010 at 11:12 PM, lakshmi priya <[email protected]> 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.gurj...@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
