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

Martin Landa landa.martin at gmail.com
Wed May 24 23:26:05 PDT 2017


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 Landa

More information about the grass-dev mailing list