[Zope] database transaction problem

[Kapil Thangavelu]

thats odd then, i would check with another python script/zsql method if
you can access the record inserted as a sanity check. zsql methods are
integrated into zope's txn machinery and thus will only commit on the
rdb at the end of the transaction (ie no batching involved). i might
suspect some sort of internal caching within xuf, if the second python
script/zsql method is able to access the record. 

possibly (unlikely) this could be an artifact of zpsycopg's own txn
isolation settings, another thing to try would be to switch from
serialized (default) to read committed.

hth,

-kapil

On Mon, 2004-03-15 at 00:36, martin f krafft wrote:
> also sprach Kapil Thangavelu <hazmat at objectrealms.net> [2004.03.15.0319 +0100]:
> > are the script and the userfolder using the same DA, if their not then
> > they are using different database connections and transaction isolation
> > is causing your problem.
> 
> Yes, they are using the same DA, which is of type PsycopgDA, version
> 1.1.10-1.1 (Debian).