Jump to content

[Solved] PostGIS needs read acces to some spatial tables


wambachr
 Share

Recommended Posts

Hi,

 

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.3998016127,6469630.074057321,3857),4326));

 

does not work (yet):

ERROR:  permission denied for relation spatial_ref_sys
CONTEXT:  SQL statement "SELECT proj4text FROM spatial_ref_sys WHERE srid = 3857 LIMIT 1"
 

this PostGIS tables/views will need r/o access:

 

spatial_ref_sys

geography_column

geometry_columns

 

Regard

walter

 

host: Tommy

db: wambachr_osm

db user: wambachr_postgres & wambachr_osmuser

Edited by wambachr
Link to comment
Share on other sites

Bingo :)

select ST_Astext(ST_Transform(ST_MakeEnvelope(905014.414896487,6467184.089152194,907460.
           3998016127,6469630.074057321,3857),4326));

                                                                            st_astext                                                                             
------------------------------------------------------------------------------------------------------------------------------------------------------------------
 POLYGON((8.1298828125 50.1205780979601,8.1298828125 50.134664322167,8.15185546875 50.134664322167,8.15185546875 50.1205780979601,8.1298828125 50.1205780979601))
(1 row)

Yes, that problem is gone.

 

regards

walter, may be the only user on tommy doing this stuff ;)

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

×
×
  • Create New...