On Tue, 26 Oct 2004, Mike Mascari wrote:
I'd like to ensure that the creation of a department also implies the creation of two to eight projects; no more, no less:
Is there no way to achieve the above stated goal in the server? Must I rely on the application to enforce consistency?
Well. It's not exactly meant to be a user facing feature, but check out CREATE CONSTRAINT TRIGGER.
Thanks, Stephan!
I read the disclaimer "It is not intended for general use" but am curious as to why it isn't a user-facing feature? Is it a function of just exposing a cleaner SQL interface, or is it a function of the trigger queue having been written after user-defined triggers, or is there some philosophical argument against allowing user-definable triggers to be deferred?
At any rate, it looks like precisely what I need.
Thanks!
Mike Mascari
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
