delete all tables in web2py/applications/name_application/databases and
recriate tables , look is import psycopg2 in db.py
ex.:
import psycopg2
db = DAL('postgres://instance_postgres:user@localhost:5432/db_name')
[image: http://itjp.net.br] <http://itjp.net.br>
http://itjp.net.b <http://itjp.net.br>r
*Ovidio Marinho Falcao Neto*
ovidio...@gmail.com
Brasil
2015-09-14 10:19 GMT-03:00 Gael Princivalle <gaelprinciva...@gmail.com>:
> 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 web2py+unsubscr...@googlegroups.com.
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
