~psycopg/psycopg/2.0.x

2005-12-11  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast.c (typecast_parse_time): cz limit in the while

	loop is 6, not 5. This solve the problem with "fractionary" time zones

	and fixes #78. 

2005-12-06  Federico Di Gregorio  <fog@initd.org>

	* lib/extras.py: added .callproc() to DictCursor as suggested

	by Philip Semanchuk.

2005-11-29  Federico Di Gregorio  <fog@initd.org>

	* MANIFEST.in: added docs/async.txt. (Closes: #75)

2005-11-26  Daniele Varrazzo  <daniele.varrazzo@gmail.com>

	* psycopg/psycopgmodule.c: fixed exceptions refcount.

	* Fixed lots of doctrings and added Epydoc-generated docs support.

2005-11-24  Federico Di Gregorio  <fog@initd.org>

	* sandbox: added all the test and creash-me files to the repository.

	* psycopg/typecast.c (typecast_dealloc): now directly calls

	PyObject_Del to avoid to segfault.

2005-11-20  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast.c: fixed problem with microseconds conversion by

	applying slightly modified patch from Ronnie Mackay.

2005-11-19  Federico Di Gregorio  <fog@initd.org>

	* lib/extensions.py: COMMITED -> COMMITTED. (Closes: #73)

	* doc/extensions.rst: included Daniele's work after minor cosmetic changes

	like using the new constants instead of numbers for transaction isolation

	levels.

2005-11-17  Federico Di Gregorio  <fog@initd.org>

	* ZPsycopgDA/pool.py: fixed connections leak by using the new name

	(PersistentConnectionPool) for the old connection pool class.

2005-11-16  Federico Di Gregorio  <fog@initd.org>

	* Preparing release 2.0 beta 6.

	* psycopg/adapter_mxdatetime.c: fixed all problems with mx conversions.

	* psycopg/typecast.c: now the timezone is set correctly even if there

	are no microseconds and/or the offset is 0;

	* examples/encoding.py: fixed example by using python utf8 encoding for

	the whole file.

	* lib/__init__.py: very nice hack from Harald Armin Massa to allow

	py2exe and similar tools to do their work without problems.

2005-11-15  Federico Di Gregorio  <fog@initd.org>

	* psycopg/psycopgmodule.c: now bails out with correct exception when one

	of the needed modules can't be imported (should fix #32.)

2005-11-14  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast.c: added typecast_parse_date and typecast_parse_time

	functions to do locale-safe date/time parsing. This would probably also

	speed-up psycopg a little bit.

2005-11-07  Federico Di Gregorio  <fog@initd.org>

	* psycopg/pqpath.c: fixed problem with uninitialized value (all this was

	started by replacing calloc() calls with PyMem_Malloc().)

2005-11-04  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast.c: a lot of changes:

	  - made typecast a new-style type

	  - removed coerce code and implemented the richcompare protocol that

	    allows to compare objects of different types

	  - much better __cmp__ method that allows to compare two typecast

	    objects and returns True if any two of the mapped oids match

	  - any object that can be used as an int works as right-hand operand

	    in __cmp__ operations 

	* psycopg/typecast_datetime.c: now typecast_PYINTERVAL_cast limit the

	scan to 'len' characters in the string (should fix #65.)

2005-11-03  Federico Di Gregorio  <fog@initd.org>

	* Applied patch from Daniele Varazzo to enable Decimal on Python

	2.3 when the module is available (run-time check, nice.)

2005-10-26  Federico Di Gregorio  <fog@initd.org>

	* setup.cfg: added include_dirs line for SUSE 9.3.

2005-10-22  Federico Di Gregorio  <fog@initd.org>

	* psycopg/cursor_type.c: added support for named cursors:

	  - .fetchXXX() methods now execute a FETCH if the cursor is named

	  - .execute() executes a DECLARE if the cursor is named

	  - .execute() fails if a named cursor is used in autocommit

	  - .executemany() can't be called on named cursors

	  - .scroll() executes a MOVE if the cursor is named

	  - .close() executes a CLOSE if the cursor is named

	  Also, a "transaction mark" was added to both the connection and the

	  cursor and an exception is raised when using a named cursor unless the

	  two marks correspond.

	* psycopg/connection_int.c: snprintf->PyOS_snprintf.

	* psycopg/psycopgmodule.c: snprintf->PyOS_snprintf.

	* psycopg/cursor_type.c: changed self->query type from C string to

	PyObject* to better manage queries in named cursors.

	* psycopg/psycopgmodule.c: cleaned up exception names (now the errors

	is printed as psycopg2.Error and not as the confusing

	psycopg2._psycopg.Error.)

2005-10-20  Federico Di Gregorio  <fog@initd.org>

	* lib/pool.py: renamed ThreadedConnectionPool to PersistentConnectionPool

	and added a connection pool that allows multiple connections per thread

	as ThreadedConnectionPool (courtesy of Daniele Varrazzo.)

2005-10-19  Federico Di Gregorio  <fog@initd.org>

	* Releasing 2.0 beta 5.

	* psycopg/adapter_mxdatetime.c: reverted to old strftime method to format

	mx.DateTime objects; the new method didn't worked in some corner-cases.

	This makes impossible to have more than 2 decimal places for seconds but

	at least we get the time right every time.

2005-10-18  Federico Di Gregorio  <fog@initd.org>

	* NOTIFY is back end working.

	* psycopg/connection_type.c: fixed problem with initialization of

	notifies list (also fixed small memory leak in connection dealloc.)

	* examples/notify.py: added NOTIFY example.

	* psycopg/cursor_type.c: added per-cursor type-casters dictionaries.

2005-10-18  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast.c: temporary fix to typecasting objects to return

	False for any comparaison except an integer in self.values (i.e., we

	don't raise an exception anymore on a coerce error.) Epydoc is now

	happy.

	* psycopg/config.h: ZETA config.h patch from Charlie Clark.

	* examples/threads.py: fixed small typo: psycopg -> psycopg2.

	* Big cleanup of unsigned chars to tame gcc 4.

	* Big cleanup of module names (i.e., psycopg2._psycopg everywhere.)

	* psycopg/config.h: added fake localtime_r for platforms missing it

	* psycopg/cursor_type.c: cursors now have a FixedOffsetTimezone

	tzinfo_factory by default.

	* psycopg/adapter_datetime.c: added tzinfo argument to psycopg2.Time and

	psycopg2.Timestamp. Also now TimestampFromTicks sets the tzinfo object

	to psycopg2.tz.LOCAL.

2005-10-17  Federico Di Gregorio  <fog@initd.org>

	* psycopg/adapter_datetime.c: we now use localtime() instead of gmtime()

	to accound for the local time-zone in timestamps.

	* psycopg/connection_type.c: fixed docstring for .cursor().

	* psycopg/psycopgmodule.c: added useful docstring for .connect().

2005-10-08  Federico Di Gregorio  <fog@initd.org>

	* psycopg/connection_type.c: isolation level upper bound set to 2.

	* lib/psycopg1.py: explicitly set isolation level to 2 on .connect()

	to mimic psycopg 1 behaviour.

	* psycopg/connection_int.c: now set isolation level from

	default_transaction_isolation backend environment value.

	* psycopg/pqpath.c: removed serialization level 3: now everybody

	(except me) has to use the mnemonics defined in psycopg2.extensions.

	* lib/extensions.py: Added mnemonics for serialization levels.

2005-10-02  Federico Di Gregorio  <fog@debian.org>

	* psycopg/cursor_type.c (psyco_curs_callproc): applied callproc

	patch from Matt Goodall (added a check on _psyco_curs_execute

	return value and substituted malloc/free with PyMem versions.) 

2005-10-01  Federico Di Gregorio  <fog@debian.org>

	* psycopg/connection_int.c: fixed segfault by moving PyErr_Format

	after GIL acquisition (closes: #50).

	* psycopg/connection_type.c: applied patch from Matt Goodall to

	fix some doc strings.

2005-09-23  Federico Di Gregorio  <fog@debian.org>

	* lib/pool.py: applied patch from piro to avoid the scan of the

	whole connection array on getconn().

2005-09-12  Federico Di Gregorio  <fog@initd.org>

	* lib/pool.py: Applied psycopg->psycopg2 patch to from bug #35.

	* ZpsycopgDA/db.py: fixed problem with OperationalError that

	resulted in cryptic message to Zope users ("'OperationalError' is

	not defined".)

2005-08-23  Federico Di Gregorio  <fog@debian.org>

	* setup.py: applied patch from Daniele Varrazzo to avoid segfaults

	when compiling with migw for Python 2.4.x.

	* psycopg/adapter_mxdatetime.c (mxdatetime_str): ported code from 1.1.x

	to convert mxDateTime object preserving the precision of fractional

	seconds.

2005-08-22  Federico Di Gregorio  <fog@debian.org>

	* ZPsycopgDA/*.py: psycopg -> psycopg2. 

	* setup.py: modified to install the module components under

	psycopg2 on windows too (thanks to Daniele Varrazzo.)

2005-08-07  Federico Di Gregorio  <fog@debian.org>

	* psycopg/config.h: added __sun__ to the symbols checked for round()

2005-07-21  Federico Di Gregorio  <fog@debian.org>

	* psycopg/adapter_datetime.c (psyco_XXXFromTicks): fixed the 1900

	years offset reported by Jeroen van Dongen (see ticket #33). 

2005-07-17  Federico Di Gregorio  <fog@debian.org>

	* Release 2.0 beta 4.

	* lib/extras.py (DictConnection.cursor): added DictConnection to

	make easier to retrieve data in DictRows.

2005-06-24  Federico Di Gregorio  <fog@initd.org>

	* psycopg/typecast_datetime.c (typecast_PYINTERVAL_cast): applied patch

	from Geert Jansen to fix interval bug due to overflow.

2005-06-18  Federico Di Gregorio  <fog@initd.org>

	* setup.cfg: some clarifications and include_dirs example for Mandrake.

	* ZPsycopgDA/DA.py: DTMLFile -> HTMLFile everywhere to fix zope

	cut&paste problems.

	* MANIFEST.in: added missing files to do bdist_rpm.

	* lib/psycopg1.py: fixed .dictfetchrow() to return None if fetchone()

	returns None instead of raising an exception.

	* ZPsycopgDA/icons: replaced corrupted icons with good ones. 

2005-06-13  Federico Di Gregorio  <fog@initd.org>

	* psycopg/psycopgmodule.c (psyco_connect): changed the port keyword

	parameter type to int (instead of string); this should fix #23.

	* psycopg/cursor_type.c (_psyco_curs_execute): now checks for

	empty queries and raise a ProgrammingError if appropriate (closes:

	#24).

	* setup.py: psycopg module renamed to psycopg2.

2005-06-02  Federico Di Gregorio  <fog@debian.org>

	* psycopg/cursor_type.c (_psyco_curs_execute): fixed segfault when

	not passing string or unicode to .execute().

2005-06-01  Federico Di Gregorio  <fog@debian.org>

	* examples/fetch.py: added example about using DECLARE CURSOR.

	* psycopg/adapter_datetime.c (psyco_TimestampFromTicks): "Hmmm,

	looks like someone forgot that C expects months to start counting

	from 0, but the Python date routines start counting from 1." That

	was me: fixed.

2005-05-31  Federico Di Gregorio  <fog@debian.org>

	* psycopg/cursor_type.c (_psyco_curs_execute): if a

	UnicodeEncodeError is raised during the converion of a unicode

	query we let it propagate insead of segfaulting.

2005-5-27  Federico Di Gregorio,  <fog@lana.initd.org>

	* tests/types_basic.py: fixed float and binary tests.

2005-05-26  Federico Di Gregorio  <fog@debian.org>

	* Release 2.0b3.

	* ZPsycopgDA/db.py (DB.convert_description): isolated description

	conversion (and fixed the conversion as per #18).

	* ZPsycopgDA/DA.py: fixed again; this time Zope should work for

	real. :/  Also fixed the type-casters (psycopg 2 added the extra

	cursor parameter) as reported in #18.

	* psycopg/psycopgmodule.c (init_psycopg): fixed Python 2.2 build. 

2005-05-19  Federico Di Gregorio  <fog@debian.org>

	* Release 2.0b2.

	* lib/extras.py (DictRow): Some extra methods for DictRow.

	* psycopg/cursor_type.c (_psyco_curs_execute): added explict check

	to avoid using None as bound variables (very importand for cursor

	subclasses calling cursor.execute(self, query, None).

2005-05-18  Federico Di Gregorio  <fog@debian.org>

	* ZPsycopgDA/DA.py (ALLOWED_PSYCOPG_VERSIONS): updated to work

	with 2.0b2 only (will support only the exact version untill final

	2.0 release.)

	* setup.py: Applied combined patch from Daniele Varrazzo and Jason

	Erickson to build on win32 using MSVC or mingw.

2005-05-15  Federico Di Gregorio  <fog@debian.org>

	* psycopg/microprotocols.c (microprotocols_adapt): fixed memory

	leak on None as suggested by gh (closes: #16).

2005-05-10  Federico Di Gregorio  <fog@debian.org>

	* lib/extras.py (DictRow): we now save a reference to the index

	itself and not to the cursor to avoid problems while accessing

	DictRow objects after reusing the cursor for a different query

	(using  Kevin Jacobs db_row would be much better but DictRow is

	just an example, right?)

2005-05-09  Federico Di Gregorio  <fog@debian.org>

	* Release 2.0 beta 1.

	* psycopg/typecast_datetime.c (typecast_PYDATETIME_cast): fixed a

	typo (pyDateTimeModuleP->pyDateTimeTypeP) that was causing errors

	with infinite datetime values.

	* psycopg/adapter_binary.c (binary_str): Py_XINCREF on the buffer

	that can be NULL on error.

	* psycopg/typecast_binary.*: applied slightly modified

	chunk/buffer object patch to allow round-trip of buffer objects

	(BYTEA columns.) 

	* psycopg/cursor_type.c (psyco_curs_executemany): applied slightly

	fixed patch from wrobell to allow iterators in .executemany().

2005-04-18  Federico Di Gregorio  <fog@debian.org>

	* MANIFEST.in: included debian directory.

2005-04-10  Federico Di Gregorio  <fog@debian.org>

	* psycopg/adapter_list.*: added list adapter. 

	* psycopg/microprotocols.c (microprotocol_getquoted): moved

	_mogrify_getquoted into utility function in the microprotocols

	library.

	* setup.py: Added extensive error message on missing datetime

	headers.

	* Applied mingw patch from Daniele Varazzo. 

2005-04-03  Federico Di Gregorio  <fog@debian.org>

	* lib/psycopg1.py (connection.autocommit): added compatibility

	.autocommit() method.

	* psycopg/psycopgmodule.c (psyco_connect): factory ->

	connection_factory.

	* lib/psycopg1.py: added psycopg 1.1.x compatibility module.

2005-03-29  Federico Di Gregorio  <fog@debian.org>

	* Applied patch to fix tuple count.

	* psycopg/pqpath.c (pq_is_busy): Staring from bug report from

	Jason Erickson fixed segfaults due to calling Python function

	without holding the GIL.

2005-03-24  Federico Di Gregorio  <fog@debian.org>

	* psycopg/adapter_binary.c (binary_escape): propagated Andrea's

	fix to binary adapter.

	* psycopg/adapter_qstring.c (qstring_quote): applied patch from

	Andrea Arcangeli to fix allocation failures (>4Gb) on 64 bit

	arches.

	* psycopg/typecast_array.c (typecast_array_tokenize): much better

	tokenization code.

2005-03-23  Federico Di Gregorio  <fog@debian.org>

	* psycopg/typecast_basic.c: all the basic casters now respect the

	passed string length.

	* psycopg/typecast.c (typecast_cast): set curs->caster to self

	during the type-casting.

	* psycopg/cursor_type.c: added "typecaster" attribute to the

	cursor (this is safe, cursors can't be shared among threads and

	the attribute is RO.)

2005-03-22  Federico Di Gregorio  <fog@debian.org>

	* psycopg/typecast_array.c: added some more structure to implement

	array typecasting.

	* scripts/buildtypes.py: new version to include array data.

2005-03-15  Federico Di Gregorio  <fog@debian.org>

	* lib/extensions.py: Added AsIs import.

2005-03-12  Federico Di Gregorio  <fog@debian.org>

	* psycopg/cursor.h: removed "qattr", not used anymore and added

	"cast", holding the typecaster currently in use.

	* Release 1.99.13.

	* psycopg/cursor_type.c (psyco_curs_executemany): implemented as a

	wrapper to extract python arguments and then call

	_psyco_curs_execute().

	* psycopg/cursor_type.c (_psyco_curs_execute): splitted away

	python argument parsing from the real execute code, to later allow

	for .executemany().

	* psycopg/cursor_type.c (_psyco_curs_buildrow_fill): modified to

	call typecast_cast().

	* psycopg/typecast.c (typecast_call/typecast_cast): modified

	typecast_call to use the new typecast_cast that avoids one string

	conversion on every cast.

2005-03-04  Federico Di Gregorio  <fog@initd.org>

	* Release 1.99.12.1.

	* psycopg/adapter_asis.c (asis_str): changed call to PyObject_Repr

	to PyObject_Str to avoid problems with long integers.

2005-03-03  Federico Di Gregorio  <fog@debian.org>

	* psycopg/typecast.h: added array casting functions.

	* scripts/maketypes.sh: does not generate pgversion.h anymore. 

	* Updated all examples for the release.

2005-03-02  Federico Di Gregorio  <fog@debian.org>

	* Release 1.99.12.

	* psycopg/adapter_*.c: added __conform__ to all adapters.

	* psycopg/adapter_qstring.c (qstring_quote): we now use

	PyString_AsStringAndSize() instead of strlen() that would stop at

	the first embedded \0 (but note that libpq quoting function will

	truncate the string anyway!)

	* COPY TO implemented using both old and new (v3) protocol.

	* psycopg/pqpath.c (_pq_copy_out_v3): implemented and working.

	* psycopg/cursor_type.c (psyco_curs_copy_to): added cursor object

	interface for copy_to.

	* COPY FROM implemented using both old and new (v3) protocol.

	* psycopg/config.h (Dprintf): declaration for asprintf is gone.

	* psycopg/pqpath.c (_pq_copy_in_v3): implemented.

2005-03-01  Federico Di Gregorio  <fog@debian.org>

	* setup.py: now we generate a slighly more verbose version string

	that embeds some of the compile options, to facilitate users' bug

	reports.

	* psycopg/cursor_type.c (psyco_curs_copy_from): we now use

	PyOS_snprintf instead of asprintf. On some platforms this can be

	bad (win32).. if that's your case, get a better platform. :/

	* psycopg/microprotocols.c (microprotocols_adapt): fixed small

	typo that made adaptation using __conform__ impossible.

2005-02-28  Federico Di Gregorio  <fog@debian.org>

	* lib/extras.py: removed AsIs adapter (now a built-in); also

	removed prepare() method from the adapters that don't use it to

	avoid an extra method call at mogrification time.

	* psycopg/psycopgmodule.c (psyco_adapters_init): added

	initialization of the AsIs adapter (adapts int, long, float and

	*wonder* None!)

	* psycopg/cursor_type.c (_mogrify_getquoted): reorganized the code

	to adapt and then call .getquoted() to obtain the quoted data into

	this new function.

2005-2-27  Federico Di Gregorio  <fog@initd.org>

	* examples/myfirstrecipe.py: fixed adapter registration. 

2005-2-7  Federico Di Gregorio  <fog@initd.org>

	* setup.py: added patch by Valentino Volonghi to build on MacOS X.

2005-01-29  Federico Di Gregorio  <fog@debian.org>

	* psycopg/pqpath.c (_pq_fetch_tuples): fixed scale-related

	segfault (*fourth* mail from Andrea. Another couple like this and

	psycopg 2 will exit alpha at warp speed.)

	* psycopg/pqpath.c (pq_fetch): _pq_copy_out_3 -> _pq_copy_out_v3

	(second and third mail from Andrea. :/)

	* psycopg/cursor_type.c (_psyco_curs_has_write_check): added check

	on .write() attribute, fixed compilation problems (first mail from

	Andrea Arcangeli.)

2005-01-20  Federico Di Gregorio  <fog@debian.org>

	* lib/extensions.py (register_adapter): added register_adapter