X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/727bd73d0beb8839286bec0d1cadf9199e3f1802..9e35e5c2b02887e361972ffbb20e65bbba0d02c7:/sql/tables.sql diff --git a/sql/tables.sql b/sql/tables.sql index caaa62df..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();