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@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).