On Mon, 2005-10-10 at 20:08 -0400, Christopher Browne wrote:
> Simon Riggs <simon at 2ndquadrant.com> writes:
> > Any table can have one source. That seems to allow me to setup links so
> > that:
> >
> > System1.Table1 -> System2.Table1
> > System2.Table2 -> System1.Table2
> >
> > Yes? Good. Will that work for inherited tables too? Can I have:
> >
> > System1.Child1 inherits System1.Parent
> > System1.Child2 inherits System1.Parent
> >
> > System2.Child1 inherits System2.Parent
> > System2.Child2 inherits System2.Parent
> >
> > System1.Child1 -> System2.Child1
> > System2.Child2 -> System1.Child2
> >
> > which is close enough to multi-master replication for most designs.

...

> In principle, it ought to be possible.

Good, thanks.

> The one problem I'd foresee is that indices aren't shared across such
> inheritance scenarios, so if the "child" tables get large, queries
> across the "parent" might wind up not being as efficient as you'd
> want.

Are you saying a slony target table can't have an index on it?

Why would you not put an index on both pieces of the inherited table?

Best Regards, Simon Riggs