Re: Making query without trigger

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Making query without trigger
Date: 2006-05-26 18:12:44
Message-ID: 20060526181244.GJ5939@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, May 26, 2006 at 12:02:44PM +0500, 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 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 | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2006-05-26 18:14:09 convert row() to array
Previous Message P.M 2006-05-26 18:00:32 Re: move from 1 database to another