Re: Please help - Mailing list pgsql-admin

From Ferdinand Smit
Subject Re: Please help
Date
Msg-id 200111201548.fAKFmPS03986@server9.telegraafnet.nl
Whole thread Raw
In response to Please help  (Mr OCP <mr_ocp@yahoo.com>)
List pgsql-admin
Hi Mike,

> Can anyone help me write a trigger on a table, I have
> created an audit table for a table and what I want
> trigger to do is to whenever a record is deleted from
> the table it should first be inserted into the audit
> table, just to keep track of whatever records are
> deleted.

Is this something ?? This archives my adres changes.

  /* Archive function */
  DROP FUNCTION fn_archive();
  CREATE FUNCTION fn_archive() RETURNS OPAQUE AS '
    BEGIN
      /* TG_OP is the function (UPDATE, DELETE, SELECT) */
      INSERT INTO adres_archive
          VALUES (OLD.name,OLD.adres,OLD.tel,current_user,now(),tg_opt);
        NEW.modtime := ''now'';
      END IF;

      RETURN NEW;
    END;
  ' LANGUAGE 'plpgsql';

  /* Archive trigger */
  DROP TRIGGER tr_archive ON adres;
  CREATE TRIGGER tr_adres_archive BEFORE UPDATE OR DELETE
  ON adres FOR EACH ROW
  EXECUTE PROCEDURE fn_archive ();

Ferdinand Smit

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Genetic algorithms
Next
From: Brian McCane
Date:
Subject: Time Zones and Brain Damage :)