Re: Deferrable constraint trigger

2018-01-26 Thread Laurenz Albe
Maciej Kołuda wrote: > I am trying to write constraint trigger to assure that at any given point of > time I have an exactly one record "active" based on the time. > To give you some background I would like to have an exactly one box per owner > active in which items will be added. > > And trigg

Deferrable constraint trigger

2018-01-25 Thread Maciej Kołuda
Hi All, I am trying to write constraint trigger to assure that at any given point of time I have an exactly one record "active" based on the time. To give you some background I would like to have an exactly one box per owner active in which items will be added. Part of the model looks like below: