Re: Losing data - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Losing data
Date
Msg-id 1213899103.22738.61.camel@jd-laptop
Whole thread Raw
In response to Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
List pgsql-general

On Thu, 2008-06-19 at 19:12 +0100, Garry Saddington wrote:
> On Thursday 19 June 2008 18:52, Adrian Klaver wrote:
> > -------------- Original message ----------------------
> > From: Garry Saddington <garry@schoolteachers.co.uk>

> > Seems like a transaction with no commit. Basically along as the session is
> > active the data is there but once the session is closed the data does not
> > persist.
> >
> Makes sense but what is to blame?

If this is indeed the problem, it is likely a lack of an explicit commit
to your connect object within zope. In pysocpg2 unless you set your
isolation level to something different it automatically creates a new
transaction for your session so if you don't do conn.commit() everything
you do will be rolled back.

Joshua D. Drake


> Regards
> Garry
>


pgsql-general by date:

Previous
From: Garry Saddington
Date:
Subject: Re: Losing data
Next
From: aklaver@comcast.net (Adrian Klaver)
Date:
Subject: Re: Losing data