Re: [GENERAL] thoughts about constraint trigger

2010-06-15 Thread Adrian von Bidder
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 be

Re: [GENERAL] thoughts about constraint trigger

2010-06-14 Thread Craig Ringer
On 15/06/10 02:33, Adrian von Bidder wrote: > Heyho! > > I was trying to implement a deferred NOT NULL constraint using a deferred > constraint trigger (on update and insert of this row) because some values > would be filled in later during the transaction, after the initial part of > the recor

[GENERAL] thoughts about constraint trigger

2010-06-14 Thread Adrian von Bidder
Heyho! I was trying to implement a deferred NOT NULL constraint using a deferred constraint trigger (on update and insert of this row) because some values would be filled in later during the transaction, after the initial part of the record has been filled. I asked myself if a type of deferred