Updating within Triggers

Поиск
Список
Период
Сортировка
От Jamie Deppeler
Тема Updating within Triggers
Дата
Msg-id 4365B5C3.3080008@doitonce.net.au
обсуждение исходный текст
Список pgsql-general
Hi trying to wtite a trigger to update summary fields in a seperate
table to do this i am planning on using trigger.
problem i have at the moment the update trigger doesnt seem to be
fireing but the insert works.

Trigger

CREATE TRIGGER "setSummary" AFTER INSERT OR UPDATE
ON "parts" FOR EACH ROW
EXECUTE PROCEDURE "material"();

function
CREATE OR REPLACE FUNCTION "partSumm" () RETURNS trigger AS
$body$
begin
  update project
      actualsummmatcost = (select sum(actualcost) from projects.material
where material."fkproject" = new.fkproject;),
      actualsummmattotal = (select sum(actualcharge) from
projects.material where material."fkprojet" = new.fkproject;),
  where project."primary" = new.fkproject;
  return new;
end;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

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

Предыдущее
От: CSN
Дата:
Сообщение: Re: PostgreSQL 8.1 vs. MySQL 5.0?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Backup problem...No BIN directory!!!