Re: Trigger question - Mailing list pgsql-performance

From Chris Travers
Subject Re: Trigger question
Date
Msg-id 019c01c3dc1b$17ba7830$7f44053d@winxp
Whole thread Raw
In response to Trigger question  (pginfo <pginfo@t1.unisoftbg.com>)
List 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



pgsql-performance by date:

Previous
From: Thomas Swan
Date:
Subject: Re: 100 simultaneous connections, critical limit?
Next
From: Harald Fuchs
Date:
Subject: Re: Trigger question