Hi all,
I'm starting a new project in which I'm using Postgresql, but I have
some problems.
I have defined a couple of tables in models/db.py. I can see and
manipulate those tables through web2py's admin interface, but when I
try to use DAL I'm facing some problems. I can connect without
problem, but afterwards I can't see nor access any tables.
Here's a copy of a python interactive session:
(courier)[julie@landing courier]$ python web2py/web2py.py -S courier
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2011
Version 1.99.3 (2011-12-09 16:18:03) stable
Database drivers available: SQLite3, pymysql, PostgreSQL
WARNING:web2py:import IPython error; use default python shell
Python 2.7.2 (default, Jan 31 2012, 13:19:49)
[GCC 4.6.2 20120120 (prerelease)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> db = DAL('postgres://postgres:********@localhost/courier')
>>> print db.tables
[]
>>>
As you can see, I apparently have no tables in my database but I can
definitely see them in web2py's admin interface!
Am I doing something wrong ?
Spec:
Web2py: 1.99.3
Postgres: 9.1.2
Psycopg2: 2.4.4
