delta/postgresql.git/src/interfaces/python, branch master

remove python module, as its moved to http://www.pygresql.org

2003-08-01T04:19:06+00:00

This is a bug in python interface module,

2003-06-25T01:09:24+00:00

postgresql-7.3.3/src/interfaces/python/pg.py.

_quote() function fails due to integer overflow if input d is larger
than max integer.

In the case where the column type is "BIGINT", the input d may very well
be 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 a
concise 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 integer

If 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 of
int(d) should fix it. The following is a patch:

Chih-Hao Huang

I succeeded by fixing up setup.py:

2003-06-12T02:15:09+00:00

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
--- setup.py~   Tue Mar 19 08:21:14 2002
+++ setup.py    Wed May 14 15:10:30 2003
@@ -30,8 +30,8 @@
        optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ]
        data_files = [ 'libpq.dll' ]
 else:
-       include_dirs=['/usr/include/pgsql']
-       library_dirs=['usr/lib/pgsql']
+       include_dirs=['../../include','../libpq','/usr/include/pgsql']
+       library_dirs=['../libpq','/usr/lib/pgsql']
        optional_libs=['pq']
        data_files = []
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

George Young

Replace functional-index facility with expressional indexes. Any column

2003-05-28T16:04:02+00:00

of an index can now be a computed expression instead of a simple variable.
Restrictions on expressions are the same as for predicates (only immutable
functions, no sub-selects).  This fixes problems recently introduced with
inlining SQL functions, because the inlining transformation is applied to
both expression trees so the planner can still match them up.  Along the
way, improve efficiency of handling index predicates (both predicates and
index expressions are now cached by the relcache) and fix 7.3 oversight
that didn't record dependencies of predicate expressions.

Use closesocket() for all socket/pipe closing, because Win32 requires

2003-04-25T01:24:00+00:00

it, and map that to close() on Unix.

Use PQfreemem() consistently, and document its use for Notify.

2003-03-25T02:44:36+00:00

Keep PQfreeNotify() around for binary compatibility.

Make "win" a separate port from "cygwin". This means you can now

2003-03-21T17:18:34+00:00

configure under native Windows (MinGW that is), but you won't get very far
compiling yet.  The dynaloader files are from Jan Wieck's patch set.

This patch fixes a bunch of spelling mistakes in comments throughout the

2003-03-10T22:28:22+00:00

PostgreSQL source code.

Neil Conway

The quote function should return a string suitable for dropping into a

2003-02-26T13:16:50+00:00

query string.  This fixes a bug where bool types sometimes returned with
a string that could not be dropped into a query.

Correction to last patch. As per the DB-API spec, we need to return None

2003-01-08T13:42:16+00:00

here, not -1.