Re: TRIGGER BEFORE INSERT

On Thursday 11 January 2007 10:26 am, Rafal Pietrak wrote:
> On Thu, 2007-01-11 at 15:10 +0100, Alban Hertroys wrote:
> > Rafal Pietrak wrote:
> > > Hi!
> > >
> > > I'm re-posting this message again in hope someone would have a look at
> > > the case again. .. it's pending.
> >
> > You were given a solution; defer the foreign key constraint.
>
> Well. I were, but probably I'm doing something wrong with 'deferring the
> trigger'. When I put:

What previous posters have said is that you need to defer the FK. So you need
to change your table definition from:
CREATE TABLE test_utarg(tm timestamp not null, nic int, amount int not
null, dnia int references test_days(id));
to:
CREATE TABLE test_utarg(tm timestamp not null, nic int, amount int not
null, dnia int references test_days(id) INITIALLY DEFERRED);
per Toms suggestion. This eliminates the need for the SET CONSTRAINTS DEFERRED
statement.

--
Adrian Klaver
aklaver(at)comcast(dot)net