[Twisted-Python] Twisted and Postgresql

[Edmund Dengler]

I am using 2.4 (at least that is what PgSQL/__init__.py says).

The result set is due to the use of the Twisted API. How does this work
with Deferreds within the adbapi?

Regards!
Ed

On Sun, 10 Aug 2003, [ISO-8859-1] Gerhard Häring wrote:

> 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
>