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@xxxxxxxxxxx
