What is your OS?
What is your version web2py?
If windows is this the start or web2py.exe web2py.py?
the drive is installed psycopg2?
Have you ever tried to postgres 8.4, makes this test.
Ovidio Marinho Falcao Neto
Web Developer
ovidio...@gmail.com
ovidiomari...@itjp.net.br
ITJP - itjp.net.br
83 8826 9088 - Oi
83 9334 0266 - Claro
Brasil
2012/7/21 Niphlod <niph...@gmail.com>
> on sql.log in your databases folder there is the excerpt of the statements
> used to create the table.
>
> I'm guessing that you implemented your app adding here and there tables
> but never defining them "in order" .
>
> This seems the kind of problem when you try to create a table with foreign
> keys pointing to a table that doesn't yet exist (i.e. Field('detail_id',
> db.details) without the db.details be defined already).
>
>
>
> On Saturday, July 21, 2012 11:55:10 AM UTC+2, Marek Mollin wrote:
>>
>> other info:
>> I am using postgres 9.1
>>
>> No migrate is not set to false. + it creates all other tables it just
>> stops at certain point and skips a few of them.
>>
>> error stack:
>>
>> Traceback (most recent call last):
>>
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\**restricted.py", line
>> 205, in restricted
>>
>> exec ccode in environment
>> File "G:/mac-backup/CLIENTS
>> 2/paczkon/web2py/applications/**menzo/models/db.py"
>> <http://127.0.0.1:8000/admin/default/edit/menzo/models/db.py>, line 212, in
>> <module>
>>
>> format=lambda r: '%s %s %s' % (r.user.email, r.status, r.price)
>>
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py"**, line 6320, in
>> define_table
>>
>> polymodel=polymodel)
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py"**, line 719, in
>> create_table
>>
>> self.create_sequence_and_**triggers(query,table)
>>
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py"**, line 1954, in
>> create_sequence_and_triggers
>>
>> self.execute(query)
>>
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py"**, line 1392, in
>> execute
>>
>> return self.log_execute(*a, **b)
>>
>> File "G:\mac-backup\CLIENTS 2\paczkon\web2py\gluon\dal.py"**, line 1386, in
>> log_execute
>>
>> ret = self.cursor.execute(*a, **b)
>> ProgrammingError: relation "delivery_type" does not exist
>>
>>
>> W dniu piątek, 20 lipca 2012 23:30:00 UTC+2 użytkownik rochacbruno
>> napisał:
>>>
>>>
>>> are you sure the migrate is not False in db = DAL(...) ?
>>>
>>> try including migrate=True in your define_table
>>>
>>> On Fri, Jul 20, 2012 at 6:17 PM, Marek Mollin <rog...@gmail.com> wrote:
>>>
>>>> Hey,
>>>> Problem is as follows.
>>>> I start a clean db in psql. Test the connection + delete all the
>>>> /databases files to fresh with remote db.
>>>> When I launch index page tables start getting created then I get error
>>>> regarding some table is missing. I check sql.log and it did not even start
>>>> creating the table (this + a few more get ommited).
>>>>
>>>> I have check_reserved in my DAL declaration. Table is not ill named:
>>>>
>>>> db.define_table('delivery_**type',
>>>> Field('name','string'),
>>>> Field('price','double'),
>>>> format=lambda r: r.name
>>>> )
>>>>
>>>> but there are others not getting created
>>>> version 1.99.7
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>
>
>
>
--
