[Qgis-user] Error creating a new Postgres layer - Enterprisedb

[Terry Schmitt]

Hi All,

New to the list and QGIS. Looks like a really cool project.

I am receiving an error when creating a PostGIS layer.
****************************************************
Accessible tables could not be determined

Database connection was successful, but the accessible tables could
not be determined.
The error message from that database was:
ERROR: schema "utl_smtp" does not exist.
****************************************************


I am using EnterpriseDB Postgres Plus Advanced Server 8.4 with Oracle
compatibility. It's essentially Postgres under the hood and pretty
much any Postgres tool can utilize the advanced server. I'm using
PostGIS 1.5.1-3.
I'm logged in as a superuser.

It doesn't matter what options I select in the "Create a New PostGIS
connection" dialog. It always throws the same error.
utl_smtp happens to be a oracle compatibility "Package". In reality
it's a schema containing a bunch of functions plus a little extra
magic written by EnterpriseDB. There are quite a few of these schemas.
I though that selecting "Only look in the geometry_columns table"
option would work, but it still errors out.
I'm pretty confident that QGIS could be made to work with EnterpriseDB
or maybe I'm missing something silly?
Anyone ever run across this before?

Thanks,
Terry Schmitt