I cannot get Postgis to work with

web2py™     Version 2.6.3-stable+timestamp.2013.09.15.17.01.20
Python     Python 2.7.3: C:\Python27\python.exe (prefix: C:\Python27)

pg.define_table('franchise',
  Field('code', 'string', length=1),
  Field('name'),
)

pg.define_table('fastfood',
  Field('franchise', 'reference franchise'),
  Field('lat', 'double'),
  Field('lon', 'double'),
  Field('geom', 'geometry()'),
)
results in

<class 'psycopg2.ProgrammingError'> function addgeometrycolumn(unknown, 
unknown, unknown, integer, unknown, integer) does not exist LINE 1: SELECT 
AddGeometryColumn ('', 'fastfood', 'geom', 4326, 'GEO... ^ HINT: No 
function matches the given name and argument types. You might need to add 
explicit type casts. 

Assistance appreciated

-- 
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/groups/opt_out.

Reply via email to