Rules for trigger execution - Mailing list pgsql-general

From pginfo
Subject Rules for trigger execution
Date
Msg-id 3E37B6F0.F9905BAD@t1.unisoftbg.com
Whole thread Raw
Responses Re: Rules for trigger execution
List pgsql-general
Hi,

Is it possible in pg to define rules for trigger execution.

I have a table with namy fields and have defined trigger ( in PL/SQL) on
updating.

If I try to update one field from the table and it is not includet in
trigger calculation,
pg takes about 15 min for updating 700K records.

If I do not have trigger installed all is ok as performance.

My Question is how to define that I need trigger execution by changin
only some fields from table?

Will be trigger execution faster if I write it in C ?

regards,
ivan.


pgsql-general by date:

Previous
From: Philip Rhoades
Date:
Subject: Digest not working?
Next
From: "William J. Stotts"
Date:
Subject: unsubscribe