Trigger for logging stuff...

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: PostgreSQL SQL List <pgsql-sql(at)postgresql(dot)org>
Subject: Trigger for logging stuff...
Date: 2001-12-06 23:02:46
Message-ID: 20011206170246.A10793@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I know I've seen an example somewhere, but can't find it right now of
a PL/pgSQL function that audit's insert/update/delete of rows in a
audit type table.

How does the PL/pgSQL function know what fields are in the row? How
can I add a by and timestamp field to the row?

Thanks!

LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-12-06 23:18:51 Re: type casting bpchar
Previous Message Keith Gray 2001-12-06 22:42:43 Re: Inline IF condition