?
where are you reading that? You can create tables dynamically. Your problem
is the bug discussed here:
self.driver = drivers.get('pg8000')
should be
self.driver = self.drivers.get('pg8000')
This is a known bug fixed in trunk some time ago.
On Wednesday, 23 May 2012 11:14:01 UTC-5, encompass wrote:
>
> And I just noticed the comment here:
> "Creating new tables dynamically is not allowed."
> Isn't this just what I am about to do?
> ---
> BR,
> Jason Brower
>
> On 05/23/2012 07:04 PM, Massimo Di Pierro wrote:
>
> This has been fixed in trunk some time ago
>
> self.driver = drivers.get('pg8000')
>
> should be
>
> self.driver = self.drivers.get('pg8000')
>
> On Wednesday, 23 May 2012 11:01:59 UTC-5, encompass wrote:
>>
>> In the console I type this:
>> db2 = DAL('postgres://postgres:********@localhost:5432/postgres')
>> And I get this:
>> In [7] : print "hi"
>> hi
>>
>> In [8] : db2 =
>> DAL('postgres://postgres:********@localhost:5432/postgres')
>> DEBUG: connect attempt 0, connection error:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>> DEBUG: connect attempt 1, connection error:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>> DEBUG: connect attempt 2, connection error:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>> DEBUG: connect attempt 3, connection error:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>> DEBUG: connect attempt 4, connection error:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/contrib/shell.py", line 233, in run
>> exec compiled in statement_module.__dict__
>> File "<string>", line 1, in <module>
>> File "/home/www-data/web2py/gluon/dal.py", line 5968, in __init__
>> raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
>> (attempts, tb)
>> RuntimeError: Failure to connect, tried 5 times:
>> Traceback (most recent call last):
>> File "/home/www-data/web2py/gluon/dal.py", line 5955, in __init__
>> self._adapter = ADAPTERS[self._dbname](*args)
>> File "/home/www-data/web2py/gluon/dal.py", line 1999, in __init__
>> self.driver = drivers.get('pg8000')
>> AttributeError: 'list' object has no attribute 'get'
>>
>> The server is located locally on an amazon system running ubuntu. I
>> created the postres user and it seems to be open and connectable. I
>> have also created the database postgres.
>> Any ideas why it wouldn't work?
>> BR,
>> Jason Brower
>>
>>
>
