On Tue, Apr 26, 2016 at 7:25 PM, Albe Laurenz <laurenz.a...@wien.gv.at> wrote:
> > > It is not the "SET search_path" statement that is blocking the truncate, > but probably some earlier statement issued in the same transaction. > You are right. I had a select against that table. Adding this line fixed it ... conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT) Reference - http://initd.org/psycopg/docs/faq.html Thanks, Jayadevan