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)
