Re: Making query without trigger - Mailing list pgsql-general

On 5/26/06, kmi@st.uz <kmi@st.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.