Re: Losing data - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Losing data
Date
Msg-id 485AEF53.7060307@wildenhain.de
Whole thread Raw
In response to Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
List pgsql-general
Hi,

Garry Saddington wrote:
> On Thursday 19 June 2008 16:55, Joshua D. Drake wrote:
>> On Thu, 2008-06-19 at 16:55 +0100, Garry Saddington wrote:
...

> Yes I thought of this but once the report is sent to the DB a separate query
> is run to get all of that teacher's reports and these are then displayed on a
> new page. They all appear here but then disappear later. Zope has transaction
> machinery that rolls everything back on an error, so Postgres must have

are you running the report within the same request that made the write?
In this case you would be in the same transaction (and see uncommitted
data) if then an exeption is raised after you display the report
the transaction would be rolled back. You should check your zope logs.

Regards
Tino

Attachment

pgsql-general by date:

Previous
From: "Douglas McNaught"
Date:
Subject: Re: Importing undelimited files (Flat Files or Fixed-Length records)
Next
From: Ralph Smith
Date:
Subject: Re: A plpgsql unidentifiable problem.