Linux Today: Linux News On Internet Time.

More on LinuxToday

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 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

Related Stories: