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

Reply via email to