Re: patch for check constraints using multiple inheritance

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Henk Enting <h.d.enting@mgrid.net>, pgsql-hackers@postgresql.org
Date: 2010-07-30T15:39:10Z
Lists: pgsql-hackers
Yeb Havinga <yebhavinga@gmail.com> writes:
> Regard the following lattice (direction from top to bottom):

> 1
> |\
> 2 3
>  \|\
>   4 5
>    \|
>     6

> When adding a constraint to 1, the proper coninhcount for that 
> constraint on relation 6 is 2. But the code currently counts to 3, since 
> 6 is reached by paths 1-2-4-5, 1-3-4-6, 1-3-5-6.

Mph.  I'm not sure that 3 is wrong.  You have to consider what happens
during a DROP CONSTRAINT, which as far as I saw this patch didn't
address.

			regards, tom lane