[Twisted-Python] Twisted and Postgresql

[Gerhard Häring]

Itamar Shtull-Trauring wrote:
> On Sat, 9 Aug 2003 18:19:25 -0400 (EDT)
> Edmund Dengler <edmundd at eSentire.com> wrote:
> 
>>When trying to transfer a row set, which was obtained using the
>>pyPgSQL module, I am having problems with specific types not being
>>jelly-able. In particular, the row itself
>>PgResultSetConcreteRow(?)(this is from memory) and PgInt2 (which I
>>found out by trying to send individual elements of the row set over).
>>Has anybody else encountered these, and is there a solution other than
>>defining my own set of jelly-able components (for example, is there a
>>stock jelly library someplace)?
> 
> Just convert them into lists and ints or dicts, [...]

First, you want to use pyPgSQL 2.4, which returns Python objects (int, 
...) instead of the pyPgSQL specific numeric types.

Second, you may want to set fetchReturnsList on the connection object to 
1 to get tuples instead of PgResultSets back.

HTH,

-- Gerhard