[sqlalchemy] Re: detached, pickled sqlalchemy collection object failing after server restart

2009-10-22 Thread rootsmith
session is trying to interact with the object that causes the problem versus my own testing of interacting with the pickled object being successful but compiling is the answer. If someone has a more robust explanation I would be very interested to hear it. On Oct 21, 10:08 pm, rootsmith ke

[sqlalchemy] Re: detached, pickled sqlalchemy collection object failing after server restart

2009-10-22 Thread rootsmith
server restart, if I just reload the page (its a web app) everything resolves itself. It is only on initial initialization of which it recovers successfully on a subsequent call. On Oct 22, 7:35 am, Michael Bayer mike...@zzzcomputing.com wrote: rootsmith wrote: Well, it appears I have answered

[sqlalchemy] detached, pickled sqlalchemy collection object failing after server restart

2009-10-21 Thread rootsmith
Hi, I have a pylons application using file based beaker sessions (not to be confused with SQLAlchemy Sessions.) I retrieve a mapped object from the database, detach it from the SQLAlchemy Session like so: Session.expunge(object) and save it to the beaker session (basically pickling it to a

[sqlalchemy] Re: table name in foreign key in wrong case on Mac OS X

2009-10-02 Thread rootsmith
it is not preserving it, which should work, but whatever routine that underlies the search for the foreign key in the example I have given is not working. On Oct 1, 10:27 pm, rootsmith ke...@rootsmith.ca wrote: Previously I was doing development of a project on an Ubuntu 9.04 machine with MySQL

[sqlalchemy] table name in foreign key in wrong case on Mac OS X

2009-10-01 Thread rootsmith
Previously I was doing development of a project on an Ubuntu 9.04 machine with MySQL 5.0 and just recently switched to doing development on a MacBook Pro. I installed identical versions of MySQL on the MacBook. I used the exact same source files and installed the same versions of all libraries