Re: [Pypgsql-users] Exception: "VACUUM cannot run inside a BEGIN/END block"

[Rene P. <re...@la...>]

Billy G. Allie:
>Of course, using the libpq.conn.query method as suggested by Adam avoids=
=20
>the need to create a cursor object, but you still need to be sure that=20
>there are no open cursors for the connection when you use (opening a=20
>connection with autocommit =3D=3D 0 will open a transaction at cursor=20
>creations time).

I see. I'm doing vacuum halfway through my algorithm (after
batch inserts/updates, before selects) and I'm beginning to
think its best to do the vacuum on a separate connection with
autocommit enabled.

--=20
Regards / Groeten,  http://www.leren.nl
Ren=E9 Pijlman        http://www.applinet.nl
 =20