[GRASS-dev] Issue with db.execute: error altering a PostGIS table

[Martin Landa]

Hi,

2017-05-25 7:37 GMT+02:00 Markus Neteler <neteler at osgeo.org>:

> The situation is that user ${TARGETDB_USER_TEST_ADMIN} has the
> permission to see schema "test". This user is the only one who may

you need to have at least select permission on schema where PostGIS
functions lives (usually it's public schema).

> ALTER TABLE test.xyz ALTER COLUMN geom TYPE geometry USING
> ST_SetSRID(geom,25832);
> ERROR:  function st_setsrid(postgis.geometry, integer) does not exist
> LINE 1: ...32n_parent1 ALTER COLUMN geom TYPE geometry USING ST_SetSRID...

[...]

Martin

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa