Re: TRIGGER BEFORE INSERT

Perfect! Thenx!

-R

On Thu, 2007-01-11 at 12:26 -0800, Adrian Klaver wrote:
> 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.
>
>