Backupping the table values

I am allowing my users to delete data from certain tables. However, to
be able to do a rollback of user changes, I decided to create another
"backup" schema that most data tables will copy data to, upon delete.

So basically what I have is:

public schema, in which there are two tables, A and B.
backup schema, in which there are two tables, A and B.

On table A and B in public I add a trigger "On Delete" which inserts
the deleted data to the matching tables in the backup scehma.

That'd work fine except the foreign keys problem. In A I have a
column, "B_id" that is a foreign key to an "id" in the B table. Thus
it means that I have to delete from A before I delete from B.

Inserting into the backup folders, on the other hand, should be
reversed, from the same reasons.

Anyone has an idea how to solve this?

--
 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent@hotmail.com
 Yahoo!: VitalyBe