Thanks for the answer. i was thinking that would be my last hope, to write custom queries for those models.
But I think i found a way around this issue playing around with the dbo_postgre file, so far, i havent had any troubles, but i think it wont work if you have tables with the same name in several schemas, anyway, im using this fix which i posted on my blog (its in spanish *use google translator ) http://www.prothotype.com/blog/archives/644/manejar-multiples-schemas-con-postgres-en-cakephp-12/ On Feb 6, 2:50 pm, "b logica" <[EMAIL PROTECTED]> wrote: > 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 > > threadhttp://groups.google.com/group/cake-php/browse_thread/thread/4f3fcad4... > > 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 -~----------~----~----~----~------~----~------~--~---
