Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


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)

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