Feature request #12304

improve message when role rights are not provided to public schema or the database is not spatially enabled

Added by Otto Dassau over 9 years ago. Updated about 7 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:20482

Description

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

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No

#2 Updated by Jürgen Fischer about 7 years ago

  • Assignee deleted (Jürgen Fischer)

Also available in: Atom PDF