Re: [GENERAL] Making query without trigger

2006-05-30 Thread kmi
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

Re: [GENERAL] Making query without trigger

2006-05-27 Thread Dawid Kuroczko
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) --

[GENERAL] Making query without trigger

2006-05-26 Thread kmi
I have trigger on updating the table. Sometimes i need to make queries without calling that trigger. How can I solve this? ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Making query without trigger

2006-05-26 Thread Andrew Sullivan
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