tsearch2 avoiding firing of triggers.....

From: "Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com>
To: "Pgsql General" <pgsql-general(at)postgresql(dot)org>
Subject: tsearch2 avoiding firing of triggers.....
Date: 2004-12-16 22:21:22
Message-ID: 20041216222122.25759@mail.net-virtual.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For some reason, I feel as though I have asked this before but I can't
find it anywhere..... I hope it is not repetitive!

I have various triggers and rules in my database, mostly for keeping
tsearch2 updated and (now) materialized views. I'd say probably 90% of
the updates to my database do not require these triggers/rules to fire
off, for example the materialized view trigger only needs to execute when
the category a record is in changes. The tsearch2 stuff, only when the
relevant data fields have changed.

Is there some way to either explicitly prevent the trigger/rules from
firing, or modify them in some way so that they only update when necessary?

Thanks!

- Greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2004-12-16 22:36:05 Re: Non-aggregate values attached to aggregates?
Previous Message Michael Fuhr 2004-12-16 22:09:32 Re: Non-aggregate values attached to aggregates?