On Feb 1, 2008 2:35 PM, Prozac <[EMAIL PROTECTED]> wrote: > > Hi, im new at this group and also kind of new using cakePHP, im having > a problem with an app im working on with multiple schemas. > > Now, in this app there are tables relations between schemas, at first > i thought i could use a different connection for each schema, but > that didn't work. > > I found in this group that someone appear to have worked this out in > this thread > http://groups.google.com/group/cake-php/browse_thread/thread/4f3fcad44af52cb2 > but i don't quite get it, and come to think that its no the same > (could be my poor english)
That was me. Sorry, that was all pretty complicated. I was also discussing more than one problem, really. Anyway, I never did figure out how to get Cake to use more than one schema. From examining the source, it appears that a lot of changes would be necessary before it could work. However, I can still make queries across schemas, but I have to make the queries directly. But I don't think that you'll be able to get Cake to honour your associations if the tables are in different schemas. In my case, I could do what I needed with a query in afterFind(). If you look at the file dbo_postgres.php you might see something that I missed. Unfortunately, I don't have any time to try to fix this, myself. It looks like phpnut was working on this earlier. But I have a feeling that the problem lies more with how Cake works rather than something that a change in dbo_postgres.php could fix :-( --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
