>It's relatively straightforward to allow check constraints to be inherited -
>but is it really possible to ever do the same with primary, unique or even
>foreign constraints?
You would either have to check each index in the hierarchy or else have
a single index across the whole hierarchy and
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > Am I misunderstanding how the mechanism works, or is this a big, not
easily
> > solved, problem?
>
> The latter. Check the list archives for previous debates about this.
> It's not real clear whether an inherited primary key shoul
On Tue, 5 Jun 2001, Christopher Kings-Lynne wrote:
> Hi guys,
>
> It's relatively straightforward to allow check constraints to be inherited -
> but is it really possible to ever do the same with primary, unique or even
> foreign constraints?
>
> ie. Say a table has a primary key and I inherit
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Am I misunderstanding how the mechanism works, or is this a big, not easily
> solved, problem?
The latter. Check the list archives for previous debates about this.
It's not real clear whether an inherited primary key should be expected
to b
