DevX: PostgreSQL Version 8’s Transaction Savepoints Can Save Your Data

“One much-lauded feature of PostgreSQL is transactions.
Transactions in a database help prevent accidental data loss or
misrepresentation.

“For example, let’s say you want to delete records from a table.
In PostgreSQL the command is:

 template1=# DELETE FROM foo; 

“However, the above command will delete all of the records in
the table. This is probably not what you want, and—unless you
were using transactions—the only way to get the data back
would be from a backup. Using transactions, getting the data back
is simple…”

Complete
Story