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