On Thu, 22 Mar 2001, Richard Huxton wrote:
I have to admit I've never tried referencing a view with a foreign key. I
don't know if it's possible and I have to admit the idea makes me
uncomfortable. Can't give a good reason why, but I'd apply constraints at
the table level.
if one can
On Thu, Mar 22, 2001 at 06:33:16PM -0500, Jan Wieck wrote:
Einar Karttunen wrote:
How do you put a UNIQUE constraint on the entire inheritance
hierarchie?
Easy. You make a unique index that covers an entire inheritance hierarchy.
If lots of table inherit a field "id" from a single