Author Name: Otto Dassau (Otto Dassau)
Original Redmine Issue: 12304
Redmine category:data_provider/postgis
Hi,
I get following error in QGIS, when I try to connect with a NOSUPERUSER user to a postgis database:
ERROR: function postgis_version() does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT postgis_version()
The problem was, that I didn't grant create/usage rights for the user to the public schema. The same message seems to appear, if the database is not spatially enabled.
Author Name: Otto Dassau (Otto Dassau) Original Redmine Issue: 12304
Redmine category:data_provider/postgis
Hi,
I get following error in QGIS, when I try to connect with a NOSUPERUSER user to a postgis database:
ERROR: function postgis_version() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts. STATEMENT: SELECT postgis_version()
The problem was, that I didn't grant create/usage rights for the user to the public schema. The same message seems to appear, if the database is not spatially enabled.
It would be helpful to improve the error message.
Regards Otto