Re: thoughts about constraint trigger - Mailing list pgsql-general

From Adrian von Bidder
Subject Re: thoughts about constraint trigger
Date
Msg-id 201006151346.49262@fortytwo.ch
Whole thread Raw
In response to Re: thoughts about constraint trigger  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Re: Moving a live production database to different server and postgres release
Next
From: Janning
Date:
Subject: Disk performance