From: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: After Update Triggers |
Date: | 2006-11-17 23:34:41 |
Message-ID: | 455E4711.8050400@fuzzy.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> When I trigger 'after insert' the function doesn't work because the
> ip_op_equipment condition is an update. When I manually enter directley
> into the table this trigger works fine when both the fluid and
> ip_op_equipment are entered as one entry.
>
> When I trigger 'after update' every row in the Processes table is
> inserted into the other tables depending on the conditionals. I end up
> with multiple inserts of the same information.
>
> Is it possible to create a trigger that inserts only one row for each entry?
Hello,
I've read the whole message several times and I have to admit I still
don't understand what are you trying to do or what is going wrong.
I'm not sure what do you mean by 'when I trigger after insert' - the
trigger is defined as AFTER UPDATE so naturally it does not fire in case
of an INSERT.
Anyway the point is you can define the trigger as AFTER INSERT OR UPDATE
and use TG_OP variable, or maybe define several triggers - one for the
UPDATE, one for the INSERT.
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | Reece Hart | 2006-11-17 23:44:49 | Re: Copy command to load data into a PostgreSQL DB |
Previous Message | Tomas Vondra | 2006-11-17 23:16:20 | Re: SPI |