trigger to access only the last transaction

Поиск
Список
Период
Сортировка
От avpro avpro
Тема trigger to access only the last transaction
Дата
Msg-id CAAQdDnnYZe+jkgEMiG2U5kJrcmq=fGNroGp0QCWUnUHBK7r+KA@mail.gmail.com
обсуждение исходный текст
Ответы Re: trigger to access only the last transaction  (Marcos Almeida Azevedo <marcos.al.azevedo@gmail.com>)
Re: trigger to access only the last transaction  (s d <daku.sandor@gmail.com>)
Список pgsql-novice
hi all,

i have two tables with several columns:
table1
idtaskhistory
performedat
...
idtask

and

table2
idtask,
manualdueat
.....


i created a trigger that does the following:

CREATE TRIGGER del1
  AFTER INSERT
  ON table1
  FOR EACH ROW
  EXECUTE PROCEDURE taskdel;

taskdel:
CREATE OR REPLACE FUNCTION taskdel()
  RETURNS trigger AS
$BODY$begin
update table2
SET
manualdueat = null,
FROM table1,
where table1.idtask = table2.idtask;
return new;
END$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION taskdel()
  OWNER TO user1;

my idea was to have the info from column "manualdueat" deleted after the table1 has been updated. the problem i face is that all columns from table2 will be deleted, not only my last entry where the insert has been done (I was thinking that table1.idtask = table2.idtask will work, but isn't); my question to you would be how to access only the last insert id in table1 and make this trigger working. or do you have another walk arround?
I'm using psql 9.4 on a windows system

thank you for your ideas,
John

В списке pgsql-novice по дате отправления:

Предыдущее
От: Marcos Almeida Azevedo
Дата:
Сообщение: Re: Split the result of a query in 2 rows
Следующее
От: Marcos Almeida Azevedo
Дата:
Сообщение: Re: trigger to access only the last transaction