· 7 years ago · Oct 12, 2018, 03:00 AM
1Connecting to database
2 ->host='localhost' port='5432' dbname='sessions' user='postgres' password='xxxxx'
3CREATE TABLE IF NOT EXISTS dggrid (id BIGSERIAL PRIMARY KEY, gid bigint UNIQUE, geo geometry, center geometry, population int, employment int);
4Traceback (most recent call last):
5 File "toolsset_up_db.py", line 22, in <module>
6 cursor.execute(query)
7psycopg2.ProgrammingError: type "geometry" does not exist
8LINE 1: ...(id BIGSERIAL PRIMARY KEY, gid bigint UNIQUE, geo geometry, ...
9 ^