X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/727bd73d0beb8839286bec0d1cadf9199e3f1802..27bc8d4f7bb907699dbb974e8159f75bead831c9:/sql/tables.sql?ds=sidebyside 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();