On Sun, May 14, 2006 at 04:18:53PM +0800, ???? wrote: > Slony use trigger to handle event on the table. So i think is it possable > to replication db1's view to a db2's table ? > > Such as: > > view ---> table > > db1.table1 > --------> db1.view ------- ..... -------> > db2.table3 > db1.table2 > > db1.table1.trigger and db2.table2.trigger : > _Slony_I_logTrigger._xxxx(xx,x,xxx)
Maybe I'm just dense this morning, but none of that made any sense to me. In any case, you can't put a trigger on a view, you'd have to use a rule. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
