[Zope-dev] Re: zPoPy oid issues

2000-12-27 Thread Casey Duncan
[EMAIL PROTECTED] wrote: Hi, The problem is inside postgresql ! They use OID type for LOB and for table'oid, PoPy (to simplify LOB handling) detect automagically LOB and returns them to the end user who can handle them easily. I study the postgresql sources on the CVS and they haven't

[Zope-dev] RE: SQL Alias leak....

2000-12-27 Thread Brian Lloyd
Making the corresponding change in Results.py appears to have corrected the SQLAlias problem. I'm not exactly sure why the SQLAlias solution is any better than doing it this way. Seems less obfuscated to me. The SQLAlias is better because otherwise Record allocates 3x the memory for

[Zope-dev] Re: zPoPy oid issues

2000-12-27 Thread Casey Duncan
Actually I found that the Postgres length function returns the string length (i.e. number of digits) of a number, so my previous message was wrong about the byte length of an oid. AFAIK they are 4 byte integers. I have found a way to retrieve oids without crashing Python or Zope. You must do an