[sqlalchemy] Re: Cannot Drop my Table!

2006-12-28 Thread vbgunz
thank you Michael. I will hopefully rap my feeble mind around SA in due time. Thank you for your response and helping to clear this up a bit. I hope to continue and learn as much as I can. Thank you again! --~--~-~--~~~---~--~~ You received this message because

[sqlalchemy] Re: Cannot Drop my Table!

2006-12-27 Thread Michael Bayer
as mentioned on IRC, you have to lose your reference to the ResultProxy first (or close() it) so that the underlying connection is returned to the connection pool, where it has a ROLLBACK issued on it. this will release the locks so that other connections can drop the table. in the case of

[sqlalchemy] Re: Cannot Drop my Table!

2006-12-27 Thread Michael Bayer
you can close on the result returned by the execute() call. however, if you just lose the reference to the result, that is as good a close since python's garbage collection can clean it up. also, you arent usually going to have code as in your example that locks that harshly (i.e. youll find