Database: Postgresql
I get this regularly when I modify a table's definition (tables using
rname):
ProgrammingError: relation "org_unit" does not exist
I either set 'migrate = False' or drop the table, delete the entry in
databases and do it over - that is when the table is empty.
I suspect it is a problem with rname.
Here is an example definition (btw the fields with 'text' will be changed
to 'citext' in Postgresql)
db.define_table('org_unit',
Field('name', 'text'),
Field('city', 'text'),
Field('post_code', length=14),
Field('street', 'text'),
Field('country', 'text'),
Field('countrycode', length = 2),
rname = '"level1"."org_unit"',
migrate = True,
fake_migrate = False)
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
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.
