Re: Trigger Question - Mailing list pgsql-general

From Alex Turner
Subject Re: Trigger Question
Date
Msg-id 33c6269f0501051409dea1528@mail.gmail.com
Whole thread Raw
In response to Re: Trigger Question  (Terry Lee Tucker <terry@esc1.com>)
Responses Re: Trigger Question
List pgsql-general
Maybe what you want is a stored procedure, not a trigger.  A trigger
will only have the data that is available from the insert operation,
and the rest of the row that was modified (It really can't have
anything else if you think about it)

Stored procedures are an exellent way to guarantee atomic access to
data in an application.

Alex Turner
NetEconomist


On Wed, 5 Jan 2005 16:35:42 -0500, Terry Lee Tucker <terry@esc1.com> wrote:
> 1) INSERT INTO logs (carr_code, ..., ..., ...)  VALUES('ABCDEFG', ..., ...);
>         logs is table A in my question
>
> 2) logs_insert fires (This is a AFTER INSERT trigger)
>
> 3) in this trigger, I need to do the following:
>         update avlds set carr_code = new.carr_code where avlds.recid = ??;
>         avlds is table B in my question
>         The questions marks indicate the first piece of data that I want to
> dynamically pass to the trigger.
>
> 4) in the same trigger:
>         update tract set order_num = avlds.order_num where tract.recid = ??;
>         tract is table C in my question
>         The question marks refer to the second piece of data that I want to pass
> dynamically into the trigger.
>
> In other terms, when the user creates a logs record that assigns a truck to a
> load, I need to update specific rows in two other tables, avlds, and tract. I
> was wanting to do this from the trigger level, but I will need the unique
> serial key of each of the existing records in avlds and tract. These two keys
> comprise the "dynamic" part of the question. I was just wondering if there is
> some way of passing dynamic data into a trigger. I don't believe there is,
> but I thought I would ask.
>
> Thanks for the input.
>  Work: 1-336-372-6812
>  Cell: 1-336-363-4719
> email: terry@esc1.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

pgsql-general by date:

Previous
From: Thomas Braad Toft
Date:
Subject: Re: Trigger Question
Next
From: Alex Turner
Date:
Subject: Re: SELECT WHERE NOT, is not working