Is QGIS compatible with PostgreSQL 8.4 Advanced enterprise DB with Oracle compatibility?

Question

Sorry for such a long question.

We are trialling EnterpriseDB Postgres Plus Advanced Server 8.4 with Oracle compatibility and PostGIS 1.5.1.

I can create a connection to the database in qgis and the test connection is successful. However when I actually connect to the database to view the available tables i get the error below.

I understand that the utl_smtp is a schema related to the oracle compatibility portion of the install, so I assumed that opting for the value "Only look in the geometry_colums table" would have solved the problem. Unfortunaley not!

Has anyone else encountered this? Or more importantly solved this?

Thanks

Andrew

Answer 1

There has been a similar post on the QGIS user mailing list not long ago: [Qgis-user] Error creating a new Postgres layer - Enterprisedb

I'm quoting:

... I had sometimes similar problems when using a postgresql database which went through some commercial products, or some GUIs. Some names (tables, fields, schemas) sometimes contained uppercase letters mixed with lowercase. This caused problems in some situations (in psql, and also in qgis, if I remember well). I had to rename manually the concerned names to lowercase, and it worked. Another solution was to include the concerned names within double quotes.

I'm absolutely not sure if you are in this case; but the fact that you mentioned some third-party software rang a bell. You could check, in psql (something as "neutral" as possible, if the schema "utl_smtp" isn't "Utl_smtp" or "Utl_Smtp" or "uTL_sMtP" or anything similar...