What happens if you delete the relevant *.table files in the /databases
folder and then turn on migrations? Does the table not get created for you?
On Monday, September 14, 2015 at 9:19:07 AM UTC-4, Gael Princivalle wrote:
>
> Using phpPgAdmin I can see that the table in question does not exist. I've
> delete it.
>
> Il giorno lunedì 14 settembre 2015 15:11:05 UTC+2, Anthony ha scritto:
>>
>> Using external tools, can you confirm whether the table in question
>> actually does exist in the database?
>>
>> On Monday, September 14, 2015 at 6:56:54 AM UTC-4, Gael Princivalle wrote:
>>>
>>> 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].
For more options, visit https://groups.google.com/d/optout.
