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
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
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 from