Re: [GENERAL] Making query without trigger

2006-05-29 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

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) -

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 anyth

[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