River Tarnell schrieb:
> Tim Alder
>> I hope somebody can repair this permission problem.
>
> This is fixed, but the query still doesn't work. This looks like a PostGIS
> issues that someone who knows more about it will need to investigate.
Sure? I stil get the error. I guess it has sth. to do with the ownership
of the spatial_ref_sys table. Is it set to osm?
> echo "ALTER TABLE spatial_ref_sys OWNER TO osm;" |\
> psql -d osm_mapnik -h sql-mapnik -U postgres
must be executed as the current owner of spatial_ref_sys. The
Permissions of geometry_columns are already correct:
osm_mapnik=> \z spatial_ref_sys
Access privileges for database "osm_mapnik"
Schema | Name | Type | Access privileges
--------+-----------------+-------+-------------------
public | spatial_ref_sys | table |
(1 row)
osm_mapnik=> \z geometry_columns
Access privileges for database "osm_mapnik"
Schema | Name | Type | Access privileges
--------+------------------+-------+-------------------------
public | geometry_columns | table | {osm=arwdxt/osm,=r/osm}
(1 row)
Peter
_______________________________________________
Maps-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/maps-l
