[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