Re: [web2py] postgres schema

2012-01-03 Thread Richard Galka
In general we use schemas to segregate data and provide access control within web2py. (Authentication and access control is at the DB level and not the web app level). As mentioned by Manuele we also use executesql to set the search path as required. In our environment each schema may provid

Re: [web2py] postgres schema

2012-01-03 Thread Manuele Pesenti
Il 03/01/2012 12:54, Johann Spies ha scritto: I could so far not get that to work. I don't think DAL's design makes provision for that. You should be able to do it outside DAL - using executesql. Regards Johann till I don't work with tables with the same name in different schema I found

Re: [web2py] postgres schema

2012-01-03 Thread Johann Spies
On 3 January 2012 12:39, Manuele Pesenti wrote: > Hi *, > is it possible even to work with postgres schemas different than public? > I guess schema are a specific peculiarity of postgres. > > I could so far not get that to work. I don't think DAL's design makes provision for that. You should be

[web2py] postgres schema

2012-01-03 Thread Manuele Pesenti
Hi *, is it possible even to work with postgres schemas different than public? I guess schema are a specific peculiarity of postgres. thanks Manuele