Linux Today: Linux News On Internet Time.

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)

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