[PyGreSQL] Cached statements

[Christoph Zwerschke]

> On Tue, May 02, 2006 at 12:13:35PM -0400, D'Arcy J.M. Cain wrote:
>> Mark Lee <mark at geneity.co.uk> wrote:
>> Not sure if this would be called a PyGreSQL issue or a PostgreSQL issue
>> but the system is acting correctly as far as it goes.  All you need to
>> do here is add "BEGIN WORK" and "END WORK" statements around the
>> query.  Otherwise every query is in the same transaction and the time
>> inside a transaction has to be consistent otherwise really strange
>> things can happen.
> 
> Thanks very much. Just spend all morning trying to get this to work.

As an aside, you can also write conn.commit() to end a transaction if 
you are using pgdb.

-- Christoph