Hi It seems that active record only supports views from the public schema in postgres? but i feel that there must be a way to overide this. Somebody with an idea about how to achive this? i have a database with 3 different schemas. After fine tuning here and there rails can read and access the different database views using active record but only those from the public schema. i have set the same privileges for all the three schemas but it seems like active record is "only in love" with the public views and tables. Anyone who knows how to overide this in active record? or using the database.yml configurations? thanks rgds tanzanite -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 3/5/07, Tanzanite Tanzanite <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Hi > It seems that active record only supports views from the public schema > in postgres? but i feel that there must be a way to overide this. > > Somebody with an idea about how to achive this? > > i have a database with 3 different schemas. After fine tuning here and > there rails can read and access the different database views using > active record but only those from the public schema. > > i have set the same privileges for all the three schemas but it seems > like active record is "only in love" with the public views and tables. > > Anyone who knows how to overide this in active record? > > or using the database.yml configurations?Set schema_search_path: public,other,schemas in database.yml jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi Jeremy, Is it possible the issue is related to this possible bug: http://dev.rubyonrails.org/ticket/7688 Mezza On Mar 6, 9:50 am, "Jeremy Kemper" <jer...-w7CzD/W5Ocjk1uMJSBkQmQ@public.gmane.org> wrote:> On 3/5/07, Tanzanite Tanzanite <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: > > > > > > > Hi > > It seems that active record only supports views from the public schema > > in postgres? but i feel that there must be a way to overide this. > > > Somebody with an idea about how to achive this? > > > i have a database with 3 different schemas. After fine tuning here and > > there rails can read and access the different database views using > > active record but only those from the public schema. > > > i have set the same privileges for all the three schemas but it seems > > like active record is "only in love" with the public views and tables. > > > Anyone who knows how to overide this in active record? > > > or using the database.yml configurations? > > Set schema_search_path: public,other,schemas in database.yml > > jeremy--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---