[Zope-DB] insert failing without raising exception: postgresql,
psycopg
Charlie Clark
charlie at egenix.com
Tue Nov 22 06:35:18 EST 2005
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 ! ::::
More information about the Zope-DB
mailing list