Addendum: the types of error I'm seeing includes SQLA trying to execute
notices from the PG server eg. one of the tracebacks I'm seeing is:
#0 PyObject_Malloc (nbytes=86) at ../Objects/obmalloc.c:756
#1 0x00455eb5 in PyString_FromString (str=0x2de0ece0 WARNING:
there is no
Another reply to my own message, sorry.
Another thing I might be doing wrong is my usage of MetaData.
The code I have looks like
db = create_engine(self.dbstring)
meta = self.table_dict['metadata']
meta.bind = db
meta.create_all()
Session = scoped_session(sessionmaker())
On Thu, 12 Aug 2010 08:47:33 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 5:10 AM, Faheem Mitha wrote:
Hi,
I'm using scoped_session with PostgreSQL to run multiple threads, each
thread creating a table.
Its generally a poor application practice for an
On Aug 12, 2010, at 9:25 AM, Faheem Mitha wrote:
Hi Mike,
Thanks for the response, but I don't follow.
When you say multiple threads are hitting the session you have
above, which session are you referring to? There is more than one
object above that could be called a session. Ie.
I
On Thu, 12 Aug 2010 09:44:04 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 9:25 AM, Faheem Mitha wrote:
Hi Mike,
Thanks for the response, but I don't follow.
When you say multiple threads are hitting the session you have
above, which session are you
On Thu, 12 Aug 2010 09:44:04 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 9:25 AM, Faheem Mitha wrote:
Hi Mike,
Thanks for the response, but I don't follow.
When you say multiple threads are hitting the session you have
above, which session are you
On Aug 12, 2010, at 11:47 AM, Faheem Mitha wrote:
On Thu, 12 Aug 2010 09:44:04 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 9:25 AM, Faheem Mitha wrote:
Hi Mike,
Thanks for the response, but I don't follow.
When you say multiple threads are hitting
[This message has also been posted.]
On Thu, 12 Aug 2010 12:47:37 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 11:47 AM, Faheem Mitha wrote:
On Thu, 12 Aug 2010 09:44:04 -0400, Michael Bayer mike...@zzzcomputing.com
wrote:
On Aug 12, 2010, at 9:25 AM, Faheem
On Aug 12, 2010, at 2:41 PM, Faheem Mitha wrote:
objects among threads, they reference their owning session in order
to load additional state. If you pass objects between threads you
should merge() them into the current thread's session first, then
use that result.
I see. That's very