[Nitro] Request for Transaction example

Reid Thompson Reid.Thompson at ateb.com
Tue Jun 5 09:13:45 EDT 2007


On Tue, 2007-06-05 at 09:08 -0400, Reid Thompson wrote:
> On Tue, 2007-06-05 at 08:26 +0300, Jonathan Buch wrote:
> > Hi,
> > 
> > > 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...
> > 
> > that I don't know, have you watched the sql output?  That's the best
> > way to make sure everything's alright.  `$DBG = true` somewhere above
> > Og.start will do.  With 32k entries it'll be a little messy, but you
> > can redirect your output to a file I guess.  :)
> > So, the first sql statement (after starting up Og) should be a begin
> > transaction.
> > 
> > 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.
> > 
> > But, if there's no TRANSACTION at the beginning, then there's something
> > wrong within Og.
> > 
> > Jo
> > 
> Ok - looks to me like something is broken then.  Can anyone confirm the
> following...( more notes inline  )
> 
> One thing that I note is that the postgresql log shows all the sql
> statements from the psql test ending with a 
> ';' but none of the Og statements end with ';' in the postgresql log.  I
> believe the BEGIN TRANSACTION is failing because it is not terminated
> with a ';'?
> 

Adding a ';' after BEGIN TRANSACTION and ROLLBACK does not fix it.


More information about the Nitro-general mailing list