We have a problem to integrate GIS software with our GIS database which is populated on Postgres Plus Advanced Server 9.2 from EnterpriseDB. We are using QGIS to maintain and analyze our GIS repository, the software is working just fine when the database in the postgres community version, but when the database in ppas; QGIS return the following error while trying to fetch the list of GIS layers:
SELECT l.f_table_name,l.f_table_schema,l.f_geometry_column,upper(l.type),l.srid,c.relkind FROM geometry_columns l,pg_class c,pg_namespace n WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND has_table_privilege('"'||n.nspname||'"."'||c.relname||'"','select') ORDER BY n.nspname,c.relname,l.f_geometry_column
returned 7 [ERROR: schema "dbms_profiler" does not exist]
And the following is the answer from EnterpriseDB:
We looked at query and it seems, issue is the way that query built. By default, PPAS stores package names in namespace table and so it is retrieving the names of packages as name of schemas hence query is failing. It works in PostgreSQL. Though, you are in postgres compatibility, we still retains some packages.
So we would recommend you to contact QGIS vendor on the same as it is not tested with PPAS.