Re: After Update Triggers
От | Bob Pawley |
---|---|
Тема | Re: After Update Triggers |
Дата | |
Msg-id | 007101c70aa2$fa0ffd00$8e904618@owner обсуждение исходный текст |
Ответ на | After Update Triggers (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: After Update Triggers
Re: After Update Triggers |
Список | pgsql-general |
I am attempting to distribute the fluid from the process table to its own table (pipe or equipment) depending on whether the fluid is classified as op, ip or eq. I didn't include the after insert trigger as there can't be a trigger until the ip_op_equipment is updated. BTW what is TG_OP that you referred to? Bob ----- Original Message ----- From: "Tomas Vondra" <tv@fuzzy.cz> To: <pgsql-general@postgresql.org> Sent: Friday, November 17, 2006 3:34 PM Subject: Re: [GENERAL] After Update Triggers >> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >
В списке pgsql-general по дате отправления: