Received: from candle.pha.pa.us (216-55-132-35.dialup.tnt01.san-diego.abac.net [216.55.132.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBAAX7m01255 for ; Mon, 10 Dec 2001 05:33:07 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id fBAAX1B03366; Mon, 10 Dec 2001 05:33:01 -0500 (EST) From: Bruce Momjian Message-Id: <200112101033.fBAAX1B03366@candle.pha.pa.us> Subject: Re: Trigger for logging stuff... In-Reply-To: <20011206173628.A12797@lerami.lerctr.org> "from Larry Rosenman at Dec 6, 2001 05:36:28 pm" To: Larry Rosenman Date: Mon, 10 Dec 2001 05:33:01 -0500 (EST) CC: PostgreSQL SQL List X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200112/92 X-Sequence-Number: 5915 In my book maybe: http://www.postgresql.org/docs/awbook.html --------------------------------------------------------------------------- > 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@lerctr.org > US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026