Search Postgresql Archives

Re: After Update Triggers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux