Re: creating audit tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Cain <cain(at)cshl(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: creating audit tables
Date: 2004-10-14 03:59:16
Message-ID: 25193.1097726356@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Cain <cain(at)cshl(dot)org> writes:
> I am trying to create audit tables for all of the tables in my
> database. The function, table and trigger create statements are below.
> Apparently, I am not doing it quite right, because I get these messages
> when I try to run the create statements below:

Trigger functions don't take any explicit parameters. Everything they
need they get through specialized mechanisms (in plpgsql, it's special
variables like tgargv).

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Frankel 2004-10-14 04:14:41 psycopg help
Previous Message Bruce Momjian 2004-10-14 03:51:53 Re: PostgreSQL CE started