[sqlalchemy] UnboundExecutionError when running session.query

2010-04-06 Thread mozillalives
I'm getting the following error when I attempt to run session.query() with a declarative base object UnboundExecutionError: Parent instance Blah is not bound to a Session; lazy load operation of attribute 'attribute' cannot proceed But why? `session` is a brand new session I've just started,

[sqlalchemy] Re: UnboundExecutionError when running session.query

2010-04-06 Thread mozillalives
Oh, forgot to mention versions SA @ 0.5.6 Python 2.5 On Apr 6, 11:08 am, mozillalives mozillali...@gmail.com wrote: I'm getting the following error when I attempt to run session.query() with a declarative base object UnboundExecutionError: Parent instance Blah is not bound to a Session

[sqlalchemy] Re: UnboundExecutionError when running session.query

2010-04-06 Thread mozillalives
Whoops, cancel that request - I found out where the error was occurring. It was happening when I iterated over the query results. Guess I need to pay more attention to the traceback next time :) On Apr 6, 11:22 am, mozillalives mozillali...@gmail.com wrote: Oh, forgot to mention versions SA

[sqlalchemy] Prepared Statements in Postgresql

2010-01-15 Thread mozillalives
Hello Everyone, I am new to both sqlalchemy and elixir, but I have been using them for the past couple of weeks and I really like them. But I have a question about prepared statements for Postgresql. For one specific application, I am doing a bunch of inserts (200,000+). From what I can tell, it

[sqlalchemy] Re: Prepared Statements in Postgresql

2010-01-15 Thread mozillalives
it did and how it works with psycopg2. From what you wrote it seems that my question is more for the psycopg2 group than here. Thanks for helping me out. Phil On Jan 15, 12:16 pm, Michael Bayer mike...@zzzcomputing.com wrote: mozillalives wrote: Hello Everyone, I am new to both sqlalchemy