On Thursday 12 February 2009 22:13:05 Craig Ringer wrote:
> Sim Zacks wrote:
> > I want a trigger on every table that inserts the old row into an audit
> > table (for updates and deletes). If the audit table was per table, then
> > I could easily have a field of type that table and insert old into
Sim Zacks wrote:
> I want a trigger on every table that inserts the old row into an audit
> table (for updates and deletes). If the audit table was per table, then
> I could easily have a field of type that table and insert old into it.
> Is there any way that I could accomplish this functionalit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The documentation says you cannot use a pseudo type for a table column,
so I was wondering if there is any way to handle what I would like to do.
I want a trigger on every table that inserts the old row into an audit
table (for updates and deletes). I
No response from the pgsql-admin list so I though I would try cross
posting here:
pgsql-sql@postgresql.org
pgsql-general@postgresql.org
I just know I am not the first to try and do this
Jim
*
Can anyone point me in a direction that may help me populate in real
time a table
