PyGreSQL changelog. =================== This software is copyright (c) 1995, Pascal Andre (andre@via.ecp.fr) Further copyright 1997 to 2003 by D'Arcy J.M. Cain (darcy@druid.net) See file README for copyright information. Version 3.7 - Fixes to quoting function. - Use Python datetime if mxDatetime is not available. - Add checks for valid database connection to methods. - Improved namespace support, handle search_path correctly. - Removed old dust and unnessesary imports, added docstrings. - Internal sql statements as one-liners, smoothed out ugly code. - Major improvements in classic pg module. Version 3.6.2 - Further fixes to namespace handling Version 3.6.1 - Fix namespace handling Version 3.6 - Better DB-API 2.0 compliance - Exception hierarchy moved into C module and made available to both APIs - Fix error in update method that caused false exceptions - Moved to standard exception hierarchy in classic API - Added new method to get transaction state - Use proper Python constants where appropriate - Use Python versions of strtol, etc. Allows WIN32 build - Bug fixes and cleanups Version 3.5 fixes and enhancements. - Add interval to list of data types - fix up method wrapping especially close() - retry pkeys once if table missing in case it was just added - wrap query method separately to handle debug better - use isinstance instead of type - fix free/PQfreemem issue - finally Version 3.4 Some cleanups and fixes. This is the first version where PyGreSQL is moved back out of the PostgreSQL tree. A lot of the changes mentioned below were actually made while in the PostgreSQL tree since their last release. - Allow for larger integer returns - Return proper strings for true and false - Cleanup convenience method creation - Enhance debugging method - Add reopen method - Allow programs to preload field names for speedup - Move OID handling so that it returns long instead of int - Miscellaneous cleanups and formatting Version 3.3 A few cleanups. Mostly there was some confusion about the latest version and so I am bumping the number to keep it straight. - Added NUMERICOID to list of returned types. This fixes a bug when returning aggregates. Version 3.2 - Add WIN32 support (gerhard@bigfoot.de) - Fix some DB-API quoting problems (niall.smart@ebeon.com) - Moved development into PostgreSQL development tree. Version 3.1 - Fix some quoting functions. In particular handle NULLs better. - Use a method to add primary key information rather than direct manipulation of the class structures. - Break decimal out in _quote (in pg.py) and treat it as float. - Treat timestamp like date for quoting purposes. - Remove a redundant SELECT from the get method speeding it, and insert since it calls get, up a little. - Add test for BOOL type in typecast method to pgdbTypeCache class. (tv@beamnet.de) - Fix pgdb.py to send port as integer to lower level function (dildog@l0pht.com) - Change pg.py to speed up some operations - Allow updates on tables with no primary keys. Version 3.0 - Remove strlen() call from pglarge_write() and get size from object. (Richard@Bouska.cz) - Add a little more error checking to the quote function in the wrapper - Add extra checking in _quote function - Wrap query in pg.py for debugging - Add DB-API 2.0 support to pgmodule.c (andre@via.ecp.fr) - Add DB-API 2.0 wrapper pgdb.py (andre@via.ecp.fr) - Correct keyword clash (temp) in tutorial - Clean up layout of tutorial - Return NULL values as None (rlawrence@lastfoot.com) - Change None to NULL in insert and update - Change hash-bang lines to use /usr/bin/env - Clearing date should be blank (NULL) not TODAY - Quote backslashes in strings in _quote (brian@CSUA.Berkeley.EDU) - Expanded and clarified build instructions (tbryan@starship.python.net) - Make code thread safe (Jerome.Alet@unice.fr) - Add README.distutils (mwa@gate.net & jeremy@cnri.reston.va.us) - Many fixes and increased DB-API compliance by chifungfan@yahoo.com, tony@printra.net, jeremy@alum.mit.edu and others to get the final version ready to release. Version 2.4 - Insert returns None if the user doesn't have select permissions on the table. It can (and does) happen that one has insert but not select permissions on a table. - Added ntuples() method to query object (brit@druid.net) - Corrected a bug related to getresult() and the money type - Corrected a bug related to negative money amounts - Allow update based on primary key if munged oid not available and table has a primary key - Add many __doc__ strings. (andre@via.ecp.fr) - Get method works with views if key specified Version 2.3 - connect.host returns "localhost" when connected to Unix socket (torppa@tuhnu.cutery.fi) - Use PyArg_ParseTupleAndKeywords in connect() (torppa@tuhnu.cutery.fi) - fixes and cleanups (torppa@tuhnu.cutery.fi) - Fixed memory leak in dictresult() (terekhov@emc.com) - Deprecated pgext.py - functionality now in pg.py - More cleanups to the tutorial - Added fileno() method - terekhov@emc.com (Mikhail Terekhov) - added money type to quoting function - Compiles cleanly with more warnings turned on - Returns PostgreSQL error message on error - Init accepts keywords (Jarkko Torppa) - Convenience functions can be overridden (Jarkko Torppa) - added close() method Version 2.2 - Added user and password support thanks to Ng Pheng Siong <ngps@post1.com> - Insert queries return the inserted oid - Add new pg wrapper (C modile renamed to _pg) - Wrapped database connection in a class. - Cleaned up some of the tutorial. (More work needed.) - Added version and __version__. Thanks to thilo@eevolute.com for the suggestion. Version 2.1 - return fields as proper Python objects for field type - Cleaned up pgext.py - Added dictresult method Version 2.0 (23/12/1997): - updated code for PostgreSQL 6.2.1 and Python 1.5 - reformatted code and converted to ANSI - Changed name to PyGreSQL (from PyGres95) - changed order of arguments to connect function - Created new type pgqueryobject and moved certain methods to it. - Added a print function for pgqueryobject Version 1.0b (4/11/1995): - keyword support for connect function moved from library file to C code and taken away from library. - rewrote documentation - bug fix in connect function - enhancements in large objects interface methods Version 1.0a (30/10/1995) (limited release): - module adapted to standard Python syntax - keyword support for connect function in library file - rewrote default parameters interface (internal use of strings) - fixed minor bugs in module interface - redefinition of error messages Version 0.9b (10/10/1995) (first public release): - large objects implementation - many bug fixes, enhancements, ... Version 0.1a (7/10/1995): - basic libpq functions (SQL access)