From: | Marc Drouin <marc(dot)drouin(at)fondex(dot)ca> |
---|---|
To: | 'Jan Wieck' <JanWieck(at)Yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Trigger functions |
Date: | 2003-04-02 12:46:42 |
Message-ID: | F4DA80054BE0604A9E05C43B1CA905B202ED3D@serveur.fondex.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Jan,
The trigger function updates the table. At the request of Tom Lane I will
post the actual table and trigger
function for you guys to have a better idea.
Marc
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Jan Wieck
Sent: Tuesday, April 01, 2003 10:44 PM
To: Tom Lane
Cc: marc(dot)drouin(at)fondex(dot)ca; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Trigger functions
Tom Lane wrote:
>
> Marc Drouin <marc(dot)drouin(at)fondex(dot)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(at)Yahoo(dot)com #
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2003-04-02 12:54:37 | Re: Is it possible for Postgresql to interact with Transaction |
Previous Message | Diogo de Oliveira Biazus | 2003-04-02 12:34:16 | Problem installing tsearch V2 on a FreeBSD |