[web2py] Re: Connecting to postgresql - where do I put schema name in the connection?

2015-06-09 Thread WebAppDev_PS
I am running postgresql 9.2 Yep you were right I had not set default schema correctly. (face palm) I also discovered the command: db.executesql("set search_path to public;") Thanks for reply On Monday, June 8, 2015 at 8:32:30 PM UTC+10, Niphlod wrote: > > except from the obvious "seems that th

[web2py] Connecting to postgresql - where do I put schema name in the connection?

2015-06-08 Thread WebAppDev_PS
I downloaded web2py and it is brilliant I love the philosophy behind it. I have one small issue I created a quick application and tested via sqllite and all is fine but I am now using my models that I created to migrate to postgresql. The error I am receiving is: no schema has been selected t