Re: [HACKERS] Deferrable triggers

2003-11-06 Thread Grant McLean
On Fri, 2003-11-07 at 11:31, Stephan Szabo wrote: > > On Thu, 7 Nov 2003, Grant McLean wrote: > > > So it would seem that if I include the clauses: > > > > on delete restrict on update restrict > > > > Then the 'deferrable' which follows

[HACKERS] Deferrable triggers

2003-11-06 Thread Grant McLean
Hi Hackers I have noticed an issue with deferrable triggers not always being deferrable. Eg: alter table subsession add constraint fk_subsession_session foreign key (session_id) references session (session_id) deferrable; alter table subsession2 add constraint fk