On 5/26/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
