Re: thoughts about constraint trigger

On Tuesday 15 June 2010 08.03:49 Craig Ringer wrote:
> AFAIK, at this point only FOREIGN KEY constraints may be deferred.

I think you didn't understand what I wrote. 9.0 allows to defer UNIQUE as
well, but not NOT NULL, which is why I wrote a derred constraint trigger to
implement it, which behaved slightly different from what I expected, which
lead me to wonder if my expectation was so far off ...

cheers
-- vbi

--
"Valentine's Day is the one holiday when everyone is expected to do
something romantic for their spouse or lover -- and if someone has both,
it's a serious problem. ... planning a 'business trip' that falls over
Valentine's Day is a typical mistake cheaters make." ... So now I'm
wondering why the RSA Conference is being held over Valentine's Day.
-- Bruce Schneier quoting the Wall Street Journal