Re: [GENERAL] Trigger in partitioned table

2007-12-20 Thread Erik Jones
On Dec 18, 2007, at 5:53 AM, Goboxe wrote: Hi, When adding sets of new child tables to a artitioned table, I need to update the triggers with new dates added as new condition. See sample below. My question is, what will happen if the update to the trigger happen at the same time as insert oper

[GENERAL] Trigger in partitioned table

2007-12-20 Thread Goboxe
Hi, When adding sets of new child tables to a artitioned table, I need to update the triggers with new dates added as new condition. See sample below. My question is, what will happen if the update to the trigger happen at the same time as insert operation to the master table? CREATE OR REPLACE