Re: PyGreSQL v3.2 doesn't support INT8 types - Mailing list pgsql-patches

From Gerhard Häring
Subject Re: PyGreSQL v3.2 doesn't support INT8 types
Date
Msg-id 20011015233626.A9330@lilith.hqd-internal
Whole thread Raw
In response to PyGreSQL v3.2 doesn't support INT8 types  (Ricardo Caesar Lenzi <ricardo@k1.com.br>)
List pgsql-patches
On Thu, Oct 11, 2001 at 09:44:58PM -0200, Ricardo Caesar Lenzi wrote:
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name        : RICARDO CAESAR LENZI
> Your email address    : RICARDO@K1.COM.BR
>
>
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)      : INTEL PENTIUM
>
>   Operating System (example: Linux 2.0.26 ELF)     : LINUX 2.2.16
>
>   PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.2devel
>
>   Compiler used (example:  gcc 2.95.2)        : GCC 2.91.66

This is missing the Python version and build options, if any (like
--with-pymalloc). Please provide these in the next bugreport.

> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> Python handle as string all int8 values from postgresql. This could be
> view when using the aggregate function count() and function nextval
> that returns an int8 value, but in python is represented like string:
>
> >> db.query("select nextval('my_seq')").getresult()
> [('2',)]
>
> >> db.query("select count(*) from films").dictresult()
> [{'count': '120'}]
>
>
> Please describe a way to repeat the problem.   Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
> see previous.
>
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
> Patch the file src/interfaces/python/pgmodule.c with the
> patch file attached in this mail.
>
>
> Please commit this before the version 7.2.
> Thanks and congratulations for the good job,
> Ricardo.

I've verified all that. The patch does the right thing.

+1 from me

Gerhard
--
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20  A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))

pgsql-patches by date:

Previous
From: Gerhard Häring
Date:
Subject: Re: Patch to fix memory leak in fetch in Python interface.
Next
From: Tom Lane
Date:
Subject: Re: Showing index details with \d on psql