T_T Hi, I am using SQLAlchemy 0.8.2 with PostgreSQL and having exactly same problem.
I have a lot of table classes inherited declarative base and only some of classes raise errors. (https://gist.github.com/yoloseem/d1c9b0f8d3cef6c196e4 ) Actually, even for same buggy classes, errors are appeared in some special environment (for me, calling exactly same function works well in web view(Flask) or shell context but always erroneous in Celery task). To figure out what causes this, I've turn logging level for 'sqlalchemy.orm' to INFO, and I found some differences between tables working well and error causing tables. (https://gist.github.com/yoloseem/b20cb4a283212ceb0439) Working things printed out about "_post_configure_properties()" and buggy things printed out about "Identified primary key columns". please somebody help me? !! 2007년 11월 24일 토요일 오전 4시 6분 3초 UTC+9, Michael Bayer 님의 말: > > > On Nov 23, 2007, at 12:53 PM, lur ibargutxi wrote: > > > my problem is that in my local configuration I have SQLAlchemy0.4.0 > > and collective.lead and my aplication work very well but when i try > > to do the same thing in the server I have this problem: > > > > ArgumentError: Error determining primary and/or secondary join for > > relationship ' Areas.idareatype2 (Areatypes)'. If the underlying > > error cannot be corrected, you should specify the 'primaryjoin' (and > > 'secondaryjoin', if there is an association table present) keyword > > arguments to the relation() function (or for backrefs, by specifying > > the backref using the backref() function with keyword arguments) to > > explicitly specify the join conditions. Nested error is "Can't find > > any foreign key relationships between 'areas' and 'areatypes'" > > > > ok....using table reflection for your tables (i.e. autoload=True)? > MySQL with MyISAM (the default) tables ? foreign keys won't reflect > in that case, you have to either specify those columns in your Table > defs manually or use InnoDB tables in your MySQL database. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
