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: <class 'psycopg2.ProgrammingError'> no schema 
has been selected to create in 


Which seems simple enough, I have not declared which schema my database 
resides in.. now checking the documentation and trying every way I can 
think of I am having no success.


My connection string is: postgres://username:password@127.0.0.1:5432/OCS_db


The OCS_db is in the schema public which is the default schema on my 
postgresql server.


I have tried these:

postgres://username:password@127.0.0.1:5432/public.OCS_db

postgres://username:password@127.0.0.1:5432/public/OCS_db

postgres://username:password@127.0.0.1:5432/public,OCS_db


None of these work, I am sure there is a simple way but I have searched 
google and all documentation but I cannot find anything on it.


Please help

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to