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
take a look at dblink in the contrib directory, it has a function called
dblink_current_query() that returns the current
query. I use it all the time.
Jim
-- Original Message ---
From: "rlee0001" <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: 11 Jan 2006 14:57:42 -
