we generally leave autocommit turned off on the DBAPI connections
(which implies theres always a transaction in progress). you might
want to see if a straight psycopg2 connection, with autocommit turned
on, can even do this. through SA, you can get at the underlying
connection and do the same thing or we can add a flag of some kind.
On Sep 19, 2006, at 2:24 PM, Sol wrote:
> Hello list,
> I want to do a VACUUM FULL ANALYZE in database maintenance code
> with SA.
>
> When i do:
> metadata.engine.execute("VACUUM FULL ANALYZE;")
>
> I get:
> SQLError: (ProgrammingError) VACUUM cannot run inside a transaction
> block
> 'VACUUM FULL ANALYZE;' {}
>
> Is there a workaround. How would i execute stuff outside a
> transaction?
>
> --
> Cheers, Sol.
>
> ----------------------------------------------------------------------
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to
> share your
> opinions on IT & business topics through brief surveys -- and earn
> cash
> http://www.techsay.com/default.php?
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
