X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/4e792546e81844a8b4ba1026358b2115452f42ab..9e35e5c2b02887e361972ffbb20e65bbba0d02c7:/sql/tables.sql diff --git a/sql/tables.sql b/sql/tables.sql index 98bf0c02..4a22a814 100644 --- a/sql/tables.sql +++ b/sql/tables.sql @@ -212,6 +212,7 @@ CREATE TABLE location_postcode ( geometry GEOMETRY(Geometry, 4326) ); CREATE INDEX idx_postcode_geometry ON location_postcode USING GIST (geometry) {ts:address-index}; +GRANT SELECT ON location_postcode TO "{www-user}" ; CREATE TRIGGER location_postcode_before_update BEFORE UPDATE ON location_postcode FOR EACH ROW EXECUTE PROCEDURE postcode_update(); @@ -226,8 +227,8 @@ CREATE TABLE import_polygon_error ( country_code varchar(2), updated timestamp, errormessage text, - prevgeometry GEOMTRY(Geometry, 4326), - newgeometry GEOMTRY(Geometry, 4326) + prevgeometry GEOMETRY(Geometry, 4326), + newgeometry GEOMETRY(Geometry, 4326) ); CREATE INDEX idx_import_polygon_error_osmid ON import_polygon_error USING BTREE (osm_type, osm_id); GRANT SELECT ON import_polygon_error TO "{www-user}";