You are trying to demonstrate that child tables do not inherit referential
integrity constraints from their parents?

Yes, that is correct.  You have to set them up on your own.  I agree it can be
annoying.

-Dan

Daniel J. Wright                           wright at pair.com
Lead Software Developer, pairNIC   https://www.pairnic.com
pair Networks, Inc.                    http://www.pair.com

On Fri, 23 Jul 2004, David Fetter wrote:

> On Thu, Jul 22, 2004 at 06:15:55PM -0400, Dan Wright wrote:
>
> > It sounds like you are doing the kind of thing that table
> > inheritance is supposed to solve.  If you use inheritance in your DB
> > tables, you could get exactly what you are asking for from slony
> > right now.
>
> Table inheritance is a Bad Thing(TM) in its current implementation.
> Please find attached an example of why this is so.
>
> Cheers,
> D
> --
> David Fetter david at fetter.org http://fetter.org/
> phone: +1 510 893 6100   mobile: +1 415 235 3778
>
> Remember to vote!
>