Re: How to determine field names in a trigger?

On Tue, Jun 29, 2004 at 01:59:11PM +1000, Justin Clift wrote:

Justin,

> I'm creating a centralised table to keep a log of changes in other tables.
>
> In thinking about the PL/pgSQL trigger to write and attach to the
> monitored tables (probably a row level AFTER trigger), I can see two
> approaches:

I think you can do this very easily with PL/Tcl.  For a somewhat
unrelated example, see General Bits issue #47,

http://www.varlena.com/GeneralBits/47.php

_I think_ there are examples closer to what you want to achieve in the
archives.  The array of column names in a trigger is $TG_relatts.

Hope this helps,

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La libertad es como el dinero; el que no la sabe emplear la pierde" (Alvarez)