[DB-SIG] Re: [PyGreSQL] Version 3.0 PyGreSQL

[Bill Tutt]

> -----Original Message-----
> From: Jeremy Hylton [mailto:jeremy@cnri.reston.va.us]
> 
> 
> Has anyone had a chance to review the quests I posted to this list
> last week?  I was surprised by the behavior of the new pgsqldb module
> with respect to transactions, cursors, and types.  I read the spec,
> but I still can't tell if the implementation is correct.  The spec is
> silent, for example, on what Python type should be returned for an SQL
> int type.
> 

A Python int should be returned here, anything else is just plane silly.
A DBI cursor doesn't have to map to a real database cursor. The existance of
the cursor is just a way to allow a speration between a database connection,
and individual statements on that connection, as some databases allow you do
do. IIRC

> Does the DB spec have an author? Is this the right place to ask
> questions?  (I realize there are lots of reason for questions to go
> unanswered.)
> 

MA Lemburg was the main driving force behind the v2.0 DBI spec.

WRT the autocomit issue, ODBC also starts in autocommit mode as well. This
is probably one fo those you like what you know questions. There are
arguments on both sides of the issue.

Bill