Re: [Zope] SQL transaction uncommited?

2005-12-18 Thread Gabriel Genellina
At Saturday 17/12/2005 09:31, Vlada Macek wrote: in ZopeBook I read that Zope's transaction are tied to SQL backend's ones. I do not know whether this applies to ZSQL methods only, but I do not expect it. I got this table: def manage_afterAdd(self, item, container): if item is

Re: [Zope] SQL transaction uncommited?

2005-12-17 Thread Andreas Jung
Forwarded Message Date: 17. Dezember 2005 13:31:23 +0100 From: Vlada Macek [EMAIL PROTECTED] To: zope@zope.org Subject: [Zope] SQL transaction uncommited? Hi, in ZopeBook I read that Zope's transaction are tied to SQL backend's ones. I do not know whether this

Re: [Zope] SQL transaction uncommited?

2005-12-17 Thread Vlada Macek
[At 17.12.2005 13:49, Andreas Jung kindly sent the following quotation.] Dealing with transaction is the task of the database adapter and not the ZSQL methods. If you need to deal with transactions yourself you must subclass the transaction manager TM and implement the hooks for commit and

Re: [Zope] SQL transaction uncommited?

2005-12-17 Thread Vlada Macek
[At 17.12.2005 15:17, Tino Wildenhain kindly sent the following quotation.] In the meanwhile I also discovered that when I put my 'insert into testtable...' to ZSQL method, the behavior is the same -- psql does not see new row, but the sequence is incremented. Now it's strange, isn't?