DevX: PostgreSQL Version 8's Transaction Savepoints Can Save Your Data
Oct 10, 2004, 07:00 (1 Talkback[s])
(Other stories by Joshua D. Drake)
Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js
"One much-lauded feature of PostgreSQL is transactions.
Transactions in a database help prevent accidental data loss or
"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