Thanks Ovidio but the error still here also with migrate=False.
ProgrammingError: relation "cavities" does not exist
LINE 1: SELECT count(*) FROM "cavities" WHERE ("cavities"."id" > 0);
Il giorno lunedì 14 settembre 2015 14:04:01 UTC+2, Ovidio Marinho ha
scritto:
>
> Use migrate=False or not use migrate in string of connection.
>
>
>
>
>
> [image: http://itjp.net.br] <http://itjp.net.br>
> http://itjp.net.b <http://itjp.net.br>r
> *Ovidio Marinho Falcao Neto*
> [email protected] <javascript:>
> Brasil
>
>
> 2015-09-14 7:56 GMT-03:00 Gael Princivalle <[email protected]
> <javascript:>>:
>
>> Hello.
>>
>> I've already read about this message error anyway I don't reach to find
>> the solution.
>>
>> Here here my db string:
>>
>> db = DAL('postgres://user:pass@localhost:5432/my_db',
>> check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
>> migrate=True)
>>
>>
>> In db.py I've add some tables with relations, and cancel these tables.
>>
>>
>> When I try to add again a table called "cavities" that is in reference in a
>> table called "model_c" (same names as the first time I've add these tables),
>> when I try to see the empty table in the administration database I've this
>> error:
>>
>> relation "cavities" does not exist
>> LINE 1: SELECT count(*) FROM "cavities" WHERE ("cavities"."id" > 0);
>>
>>
>> The table:
>>
>> db.define_table('cavities',
>> Field('name', type='string', requires=IS_NOT_EMPTY()),
>> format='%(name)s')
>>
>>
>> I've tried to add migrate=True to the connection string, I've cancel
>> manually all old tables in the db, I've add the app in a totally new web2py
>> application, and cancel also all the database app folder.
>>
>> Always the same error.
>>
>>
>> Someone can give me a help?
>>
>>
>> Thanks.
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> 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 [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
