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:36:28
Message-ID: 20011206173628.A12797@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

This may be a dup...

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2001-12-07 01:45:35 Re: how to chane the type
Previous Message Stephan Szabo 2001-12-06 23:18:51 Re: type casting bpchar