> On Fri, May 26, 2006 at 12:02:44PM +0500, [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 need your function to decide whether the "don't do anything" > conditions apply, and then not do anything. The trigger still fires, > but it doesn't do anything. > > A > > -- > Andrew Sullivan | [EMAIL PROTECTED] > "The year's penultimate month" is not in truth a good way of saying > November. > --H.W. Fowler > Yep, decided the best way to ignore trigger is checking function in trigger body. In my "Updating" case i used checking (old.fieldname <> new.fieldname).
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
