I wrote:
> fully SQL3. I just had an idea that might easily turn it to
> do the right thing.
ON <event> RESTRICT triggers are now executed after the statement allways, ignoring any explicitly set
deferredmode.
This is pretty close to Date's SQL3 interpretation, or IMHO better. Date says that they are checked BEFORE each
ROW, but that would ignore the SET character of a statement. Now we have correct semantics for all 4
possible referential actions.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck@debis.com (Jan Wieck) #