Skip site navigation (1) Skip section navigation (2)

copy DELETES to audit table

From: "jason watkins" <jason_watkins(at)pobox(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: copy DELETES to audit table
Date: 2000-08-21 23:20:48
Message-ID: 005401c00bc6$764d9540$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
I'd like to have a trigger that does something like serialize any row to a
text string, then copys it into an audit table befor allowing the delete...
having an restore function that can deserialize would be nice as well, but
not criticle..

the goal would be to allow a couple people who need the ability to remove
rows the ability to do so, but to not loose the information for a week or
so, so that the choice can be double checked by someone else.

jason watkins

pgsql-sql by date

Next:From: Tom LaneDate: 2000-08-21 23:21:16
Subject: Re: Copying data with triggers
Previous:From: Jan WieckDate: 2000-08-21 20:47:24
Subject: Re: 8K Limit, whats the best strategy?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group