Is your database spatially enabled ? Try to run 'create extension postgis;" in pgadmin.
Bests, Olivier On Feb 27, 2015 8:08 AM, "Otto Dassau" <[email protected]> wrote: > Hi, > > I cannot login to a postgis database with QGIS as a normal user 'testuser'. > But I can login with psql and using pgadmin3. > > CREATE ROLE testuser LOGIN > NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; > > I get following error in QGIS: > > CET ERROR: function postgis_version() does not exist at character 8 > CET HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > CET STATEMENT: SELECT postgis_version() > > If I create another user as SUPERUSER I can login without problems. What > could be the reason for this? > > Thanks a lot > Otto > _______________________________________________ > Qgis-developer mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
