Quote Originally Posted by nnidza View Post
I don't need any transactions now as I am under the PostgreSQL protections? Am I right?
No. You still may need to use transactions.

A classic example is the General Journal posting. Say you have a table containing daily postings of debits and credits to various accounts. You want to post those amounts to their specific debit and credit accounts to that your accounts remain balanced. If any of them fail you want to revert all of them. You do that by
Begin;
post the daily transactions to the general ledger
Commit;
(or Rollback if things didn't go well).
See http://www.postgresql.org/docs/8.1/i...nsactions.html

This avoids the "dirty read" problem:
http://www.informit.com/articles/art...&seqNum=6&rl=1