[Pypgsql-devel] [ pypgsql-Bugs-636368 ] insert with longinteger value

[<no...@so...>]

Bugs item #636368, was opened at 2002-11-10 23:31
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=636368&group_id=16528

Category: PgSQL
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Gerhard Häring (ghaering)
Summary: insert with longinteger value

Initial Comment:
in an insert statement, a python long integer value like 1010L 
results in a parser error (something like "parser error at l".
After 
conversion to a normal integer value with int() everything works 
fine.
There will be a problem with very large integer values which 
can not be converted with int().

The error occured with the 
latest beta version. Pythonversion was 2.2.2, PostgreSQL-
Version was 7.2.3

Christoph Becker


----------------------------------------------------------------------

>Comment By: Gerhard Häring (ghaering)
Date: 2002-11-11 23:28

Message:
Logged In: YES 
user_id=163326

Sorry, can't reproduce here:

>>> cursor.execute("select * from test where a=%s", (10L**15,))
>>> print cursor.fetchone()
[1000000000000000L]

Please upload a test case that demonstrates the problem.

----------------------------------------------------------------------

Comment By: Gerhard Häring (ghaering)
Date: 2002-11-11 17:00

Message:
Logged In: YES 
user_id=163326

Hmm. I thought I fixed that for 2.3beta1. Plan to check it
later today.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=116528&aid=636368&group_id=16528