RE: Approaching migration - various question, more

[wojtek]

Hi,

>--> just changing :new will not help. To change the data
>in the database, you have to use some dml-statement like
>insert/update/delete, usually update.

Thanks, it worked. Although it would be nice to be able to just update
:NEW. But triggers are evil anyway...

--

But I have another problem, I can't find the equivalence of:

ALTER TABLE chicken ADD CONSTRAINT chickenREFegg
    FOREIGN KEY (eID) REFERENCES egg(eID)
    INITIALLY DEFERRED DEFERRABLE;

In other words: how do I defer foreign key check until commit?

Regards,
Wojtek