Re: Making query without trigger

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "kmi(at)st(dot)uz" <kmi(at)st(dot)uz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Making query without trigger
Date: 2006-05-27 17:48:49
Message-ID: 758d5e7f0605271048v248f15abw9293171eb2911ada@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/26/06, kmi(at)st(dot)uz <kmi(at)st(dot)uz> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2006-05-27 18:01:56 a row disapearing
Previous Message P.M 2006-05-27 16:39:52 Re: error in SELECT