Advice for generalizing trigger functions

Поиск
Список
Период
Сортировка
I've created quite a few functions that log modifications to various history tables. (the history table has the same
nameas the base table but is prefixed by the 'History.' schema.) The only difference between functions I can find is
thetable name.
 

Is there any way to generalize these myriad of functions into one?


Below is a sample of a typical logging trigger function.

Regards,
Richard Broersma Jr.


CREATE OR REPLACE FUNCTION "project"."log_managers_ops"()
RETURNS trigger AS
$BODY$
BEGIN

    IF TG_OP IN ( 'UPDATE', 'DELETE' ) THEN             UPDATE History.Managers AS M            SET endts = now()
  WHERE M.manager_id = OLD.manager_id            AND now() BETWEEN M.startts AND M.endts;                end IF;
   IF TG_OP IN ( 'UPDATE', 'INSERT' ) THEN        INSERT INTO History.Managers         VALUES ( now()::timestamptz,
'INFINITY'::timestamptz,NEW.*);
 
         RETURN NEW;             END IF;
    RETURN OLD;

END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER;



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

Предыдущее
От: Rick Innis
Дата:
Сообщение: Re: Misnamed field in subquery does not cause error when field name exists in parent query
Следующее
От: chester c young
Дата:
Сообщение: Re: Advice for generalizing trigger functions