[Nitro] Request for Transaction example
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