[Zope-DB] insert failing without raising exception: postgresql, psycopg

[Charlie Clark]

On 2005-11-22 at 12:27:42 [+0100], freeman at tllc.com wrote:
> 
> Though the insert is failing, a sequence column in the target table is
> apparently being incremented by the failing insert.  (I deduce this
> from the fact that subsequent Z SQL test inserts show sequence gap
> of 12 after each failed insert attempt, while no gap occurs when I
> call the Z SQL method repeatedly via Zope's "test" tab.)
> 
> I will appreciate any suggestions as to how I might troubleshoot this.

You should probably compile psycopg to give debug information and I would 
suggest updating to the most recent build in the 1 series. In addition you 
might want to try using our mxODBCZopeDA to see if the error is with the 
DA/driver or in Zope itself.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2005-10-17: Released mxODBC.Zope.DA 1.0.9        http://zope.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::