Re: Lion and WO

2011-08-07 Thread Ramsey Gurley
Right, on Lion client. The big problem is the change in the way the postgres user is set up. Evidently, it existed as 'postgres' on older versions, but it is now '_postgres' with no shell. Ramsey On Aug 6, 2011, at 10:51 PM, Johan Henselmans wrote: Op 7 aug. 2011, om 06:37 heeft Ramsey

Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the topic brought up: http://lists.apple.com/archives/webobjects-dev/2003/Feb/msg00395.html which gives me the faint hope that such things are possible. But then again

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Karl
I don’t think that we ever really needed to give much thought to that. Its automatic. Karl On 2011-08-08, at 12:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? Googling the

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread David Avendasora
On Aug 8, 2011, at 5:19 AM, Lars Sonchocky-Helldorf wrote: Dear List, I've got a design question: Is it possible to manage cross database ManyToMany relationships with EOF? I believe that at the point of cross-DB-anything, you are no longer talking about what WO/EOF can do, you are

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Cail Borrell
Hi Lars, Like Karl said it should pretty much just work. As long as you do not flatten such relationships and also make sure your qualifiers on either side do not include predicates from the other. In short you just need to keep in mind that EOF will generate SQL that tries to join tables

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
Am 07.08.2011 um 23:37 schrieb Karl: I don’t think that we ever really needed to give much thought to that. Its automatic. Well, so i thought too (in the beginning) but in my case it didn't work in the end. So I conclude, i must have done something what this automatic did not like. Any

Re: Design question: are cross database ManyToMany relationships possible

2011-08-07 Thread Lars Sonchocky-Helldorf
Am 08.08.2011 um 00:19 schrieb Cail Borrell: Hi Lars, Like Karl said it should pretty much just work. As long as you do not flatten such relationships and also make sure your qualifiers on either side do not include predicates from the other. The Dbs are two MySQL DBs on different