Re: insert failing without raising exception: postgresql, psycopg
Charlie Clark <[email protected]>
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
On 2005-11-22 at 12:27:42 [+0100], [email protected] 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 ! ::::