Subject | Knowing the previous rows |
---|---|
Author | Walter R. Ojeda Valiente |
Post date | 2015-08-06T18:12:58Z |
Hello everbody
Always that a transaction that did an UPDATE ends with a COMMIT or a ROLLBACK this left back a row.
So, my question is: There is some way to know those previous rows?
This can be very useful for me because I shall know how many garbage a table has.
For example, if a row has the ID 1234, it would be great a SELECT which show me something like that:
1234 INSERT COMMIT
1234 UPDATE COMMIT
1234 UPDATE ROLLBACK
1234 UPDATE COMMIT
1234 UPDATE COMMIT
1234 UPDATE COMMIT
Saying me some "story" of that row.
Is that possible?
Thanks in advance.
Greetings.
Walter.