Terry Schmitt claviota avec insistance:
...
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 thought 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?
No. But 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 cas; 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...
Hope it helps
A+
Pierre
--
____________________________________________________________________________
Pierre Chevalier Géologue EI
Mesté Duran
32100 Condom
Tél+fax : 09 75 27 45 62
05 62 28 06 83
06 37 80 33 64
Émail : pierrechevaliergeolCHEZfree.fr
icq# : 10432285
skype : pierre.chevalier1967
http://pierremariechevalier.free.fr/pierre_chevalier_geologue
____________________________________________________________________________
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
