Thanks guys but I cannot use C on the database server. I am a lowly
coder in a large organization and even getting pl/PGSQL loaded into the
production database practically took an act of congress. So for now
solutions that require stored procedures to be written in C are not an
option.
pl/Perl wou
You might want to consider an inheritance model for this I use it for
Sarbanes-Oxley and a viurtual rollback system...
http://www.postgresql.org/docs/8.0/interactive/tutorial-inheritance.html
"rlee0001" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I want to write a row-leve
am 11.01.2006, um 14:57:42 -0800 mailte rlee0001 folgendes:
> I want to write a row-level trigger in PL/PGSQL that inserts rows into
> an audit log whenever records are UPDATEd for a specific table. In my
> audit log I want to record:
Why do you want to reivent the wheel?
http://pgfoundry.org/pro
an 2006 14:57:42 -0800
Subject: [GENERAL] Returning SQL statement
> I want to write a row-level trigger in PL/PGSQL that inserts rows into
> an audit log whenever records are UPDATEd for a specific table. In my
> audit log I want to record:
>
> * The primary key of the record being
I want to write a row-level trigger in PL/PGSQL that inserts rows into
an audit log whenever records are UPDATEd for a specific table. In my
audit log I want to record:
* The primary key of the record being modified (easy)
* The current date (easy)
* The username of the user (easy)
* The SQL state
