[Qgis-user] Error creating a new Postgres layer - Enterprisedb
Pierre Chevalier Géologue
pierrechevaliergeol at free.fr
Thu Oct 7 02:56:48 PDT 2010
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
____________________________________________________________________________
More information about the Qgis-user
mailing list