search

whosonfirst / go-whosonfirst-pgis

This is not ready to use. It is still being tested. It will probably be renamed.
BSD 3-Clause "New" or "Revised" License
3 stars 2 forks source link

Update README #12

Closed stepps00 closed 6 years ago

stepps00 commented 6 years ago

Following the set up instructions, I found (what I think is) an error.

Before granting access to the table, the table needs to be created..

CREATE TABLE whosonfirst (id BIGINT PRIMARY KEY,parent_id BIGINT,placetype_id BIGINT,is_superseded SMALLINT,is_deprecated SMALLINT,meta JSON, geom_hash CHAR(32), lastmod CHAR(25), geom GEOGRAPHY(MULTIPOLYGON, 4326), centroid GEOGRAPHY(POINT, 4326))

then

GRANT ALL ON TABLE whosonfirst TO whosonfirst

Otherwise, I get the error:

ERROR:  relation "whosonfirst" does not exist