Re: Trigger question

From: "Chris Travers" <chris(at)travelamericas(dot)com>
To: "pginfo" <pginfo(at)t1(dot)unisoftbg(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Trigger question
Date: 2004-01-16 10:19:24
Message-ID: 019c01c3dc1b$17ba7830$7f44053d@winxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Exists in pg any way to define the trigger execution only if I have
> changes on some fields?

No, but you chould check for those fields and return if no changes have been
made. Depending on how intensive the trigger is, this might help. You may
also want to look at statement-level triggers or conditional rules.

Best Wishes,
Chris Travers

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Harald Fuchs 2004-01-16 13:05:20 Re: Trigger question
Previous Message Thomas Swan 2004-01-16 06:24:45 Re: 100 simultaneous connections, critical limit?