Re: [sqlalchemy] idle in transaction using ZopeTransactionExtension with postgres

2015-02-26 Thread Wichert Akkerman
> On 26 Feb 2015, at 17:02, Robert Daniels wrote: > > > I'm using ZopeTransactionExtension (postgresql) as: > > DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension())) > Base = declarative_base() > > > When I invoke > > result = DBSession.execute("some sql query") >

[sqlalchemy] idle in transaction using ZopeTransactionExtension with postgres

2015-02-26 Thread Robert Daniels
I'm using ZopeTransactionExtension (postgresql) as: DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))Base = declarative_base() When I invoke result = DBSession.execute("some sql query") The result comes back fine, however I notice when I review the server statu