Re: [Python-sybase-misc] Regression in 0.39 Connection().execute()

[Andrew M. <an...@ob...>]

>You should note however that Connection.execute is deprecated so that 
>you should probably plan to migrate to a cursor at some stage.

When I was working on my PostgreSQL adapter (ocpgdb), I initially added
a Connection.execute before I had implemented the Cursor logic, intending
to remove it when done. However, there are SQL statements that PostgreSQL
will not execute within a cursor which necessitates some mechanism for
sending commands not within a cursor. A Connection.execute method seems
like the most natural answer to me, so I've left it in. It's also quite
a bit faster for some operations, as it requires considerably less round
trips to the server.

-- 
Andrew McNamara, Senior Developer, Object Craft
http://www.object-craft.com.au/