Moving from SQLite to Postgres and when running Database Administration we're getting unknown field type errors when using a db reference i.e. Field('Client', db.Client) Any advice or work arounds?
TIA, Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 204, in restricted exec ccode in environment File "C:/web2py/applications/OAS/models/oa.py", line 358, in <module> Field('Interpretation_Type', db.Interpretation_Type)) File "C:\web2py\gluon\dal.py", line 5114, in define_table polymodel=polymodel) File "C:\web2py\gluon\dal.py", line 624, in create_table (field.type, field.name) SyntaxError: Field: unknown field type: db.Client for Client Code listing: precision, scale = map(int,field.type[8:-1].split(',')) ftype = self.types[field.type[:7]] % \ dict(precision=precision,scale=scale) elif not field.type in self.types: raise SyntaxError, 'Field: unknown field type: %s for %s' % \ (field.type, field.name) Model: db.define_table('Client', Field('Company', 'string'), Field('Address', 'string'), Field('Town', 'string'), Field('State', 'string'), Field('Zip', 'string'), Field('Activity', 'integer'), Field('Account', 'integer'), format='%(Company)s') db.define_table('Contact', Field('Client', db.Client), Field('Surname', 'string'), Field('First_Name', 'string'), Field('Position', 'string'), Field('Department', 'string'), Field('eMail', 'string'), Field('Mobile', 'string'), Field('Phone', 'string'), Field('Fax', 'string'), format='%(Surname)s - %(First_Name)s') Environment: Windows 7 64bit Current Postgresql (64bit) with psycopy2 web2py source from trunk: (1, 99, 4, datetime.datetime(2011, 12, 31, 4, 51, 15), 'stable') Python 2.7.2: C:\Python27\python.exe