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

[Martin Landa]

2017-05-25 8:26 GMT+02:00 Martin Landa :
>> 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).

also 'public' schema must be in the search path (set search_path to ...). Ma

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa
___
grass-dev mailing list
grass-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-dev

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

[Martin Landa]

Hi,

2017-05-25 7:37 GMT+02:00 Markus Neteler :

> 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
___
grass-dev mailing list
grass-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-dev