[Nitro] Request for Transaction example

Jan Mikkelsen janm-nitro at transactionware.com
Tue Jun 5 02:43:55 EDT 2007


Jonathan Buch wrote:
 >> > > It still appears to be committing on each save -- if all
 > > records were in
 >> > > a single transaction, no rows should be present until the
 > > final commit
 >> > > -- correct????
 >> > >
 >> > > yet...

Yes, that is correct.

 > > [ ... ]
 > > There's all kinds of transaction 'levels', read
 > > http://www.postgresql.org/docs/8.0/static/transaction-iso.html
 > > for more information.  It says 'read committed' is the
 > > standard level,
 > > but it might be uncommitted for you, if you can select stuff
 > > while
 > > transaction is still in progress.

Postgresql doesn't have dirty reads:  read uncommitted is turned into 
read committed.

Regards,

Jan.



More information about the Nitro-general mailing list