Re: disappearing data

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Subject: Re: disappearing data
Date: 2010-08-23 13:30:39
Message-ID: 201008230630.39750.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 23 August 2010 3:15:28 am Magnus Hagander wrote:
> On Mon, Aug 23, 2010 at 12:12, Garry Saddington

>
> I don't know anything about Zope, but it sounds like the db adapter
> opens a transaction and never commits it. Perhaps the previous version
> was working in autocommit mode by default, and the new one doesn't.
>
> --
>  Magnus Hagander
>  Me: http://www.hagander.net/
>  Work: http://www.redpill-linpro.com/

Sounds like it to me, see here for more detailed info:
http://initd.org/psycopg/docs/usage.html#transactions-control

You might also want to ask this question on the the Psycopg mailing list:
http://lists.initd.org/mailman/listinfo/psycopg

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2010-08-23 13:38:46 Re: Massively Parallel transactioning?
Previous Message Scott Marlowe 2010-08-23 10:19:33 Re: Sequence reset