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      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461