- Notifications
You must be signed in to change notification settings - Fork28
Commit92798de
committed
This is a bug in python interface module,postgresql-7.3.3/src/interfaces/python/pg.py._quote() function fails due to integer overflow if input d is largerthan max integer.In the case where the column type is "BIGINT", the input d may very wellbe larger than max integer while its type, t, is labeled 'int'.The conversion on line 19, return "%d" % int(d), will fail due to"OverflowError: long int too large to convert to int".Please describe a way to repeat the problem. Please try to provide aconcise reproducible example, if at all possible:----------------------------------------------------------------------[1] create a table with a column type 'BIGINT'.[2] use pg.DB.insert() to insert a value that is larger than max integerIf you know how this problem might be fixed, list the solution below:---------------------------------------------------------------------Just changing the conversion at line 19 of pg.py to long(d) instead ofint(d) should fix it. The following is a patch:Chih-Hao Huang
1 parentdd23a88 commit92798de
1 file changed
+1
-1
lines changedLines changed: 1 addition & 1 deletion
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
17 | 17 | | |
18 | 18 | | |
19 | 19 | | |
20 | | - | |
| 20 | + | |
21 | 21 | | |
22 | 22 | | |
23 | 23 | | |
| |||
0 commit comments
Comments
(0)