Re: [SQL] Make Trigger run after completion of ENTIRE transaction

2006-09-20 Thread Markus Schaber
Hi, Henry, Henry Ortega wrote: > This maybe more of a theoretical question, can you actually make a > Trigger run > after completion of the entire transaction? [...] > ... another 20-30 more inserts.. Which frontend do yu use? Maybe COPY is better than insert. > The trigger actua

[SQL] Make Trigger run after completion of ENTIRE transaction

2006-09-19 Thread Henry Ortega
This maybe more of a theoretical question, can you actually make a Trigger run after completion of the entire transaction?   Here's what I have: LOG user   |    startdate   |   enddate   enddate is getting updated by a trigger (on insert or update).   I have the following transaction: BEGIN