Re: Trigger functions - Mailing list pgsql-general

From Jan Wieck
Subject Re: Trigger functions
Date
Msg-id 3E8A5C81.F49CC132@Yahoo.com
Whole thread Raw
In response to Trigger functions  (Marc Drouin <marc.drouin@fondex.ca>)
List pgsql-general
Tom Lane wrote:
>
> Marc Drouin <marc.drouin@fondex.ca> writes:
> > The function is triggered on insert and is supposed to fill a field in the
> > table based on three other fields of the same table (ex: field D = Field A X
> > Field B X Field C).  The addition of the trigger to teh table has slowed
> > down the insert procedd considerably.  It takes approximatly two second for
> > a simple insert.
>
> That's pretty slow, all right, but if you're not going to show us the
> details there's not much advice we can offer.

Does the trigger update the table or the pseudo row NEW?


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Earth distance
Next
From: Jan Wieck
Date:
Subject: Re: