On 5/26/06, kmi@xxxxx <kmi@xxxxx> wrote:
I have trigger on updating the table. Sometimes i need to make queries without calling that trigger. How can I solve this?
You could try disabling the trigger (ALTER TABLE ...), doing you updates and reenabling the trigger (ALTER TABLE) -- all within transaction. If you do it this way, your change in triggers won't be visible to any other transaction.