Guten Tag Richard Huxton,

Am Donnerstag, 15. Januar 2004 um 17:10 schrieben Sie:

RH> On Thursday 15 January 2004 13:13, pginfo wrote:
>> Hi,
>> I am using pg 7.4.1 and have created a trigger over table with 3 M rows.
>> If I start masive update on this table, pg executes this trigger on
>> every row and dramaticaly slows the system.
>> Exists in pg any way to define the trigger execution only if I have
>> changes on some fields?

That not, but perhaps a STATEMENT Level Trigger could help. It´s a new
feature in 7.4.x and rather undocumented.
"FOR EACH STATEMENT" probably this can help you a bit.

Christoph Nelles

Mit freundlichen Grüssen
Evil Azrael                            mailto:[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to