| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Losing data |
| Date: | 2008-06-19 23:44:19 |
| Message-ID: | 485AEF53.7060307@wildenhain.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ralph Smith | 2008-06-19 23:53:10 | Re: A plpgsql unidentifiable problem. |
| Previous Message | David Spadea | 2008-06-19 23:22:37 | Re: renumber table |