Hi Adrian, as far as I can remember there are two parameters in the table sde 'db_tune' that must be set to the PG_GEOMETRY type. I remember having the same problem some times ago, due to the fact that I had set only one parameter to the right type.
Then, of course, you will have to delete your geometry type and re-import it. Let us know if you sort it out. regards paolo 2015-01-15 21:23 GMT+01:00 Adrian Term <adrian.t...@gmail.com>: > I have the following setup : > ArcGIS 10.2.2 for Desktop Advanced > ArcGIS 10.2.2 for Server > QGIS 2.6.1 Brighton > PostgreSQL 9.2.9-3 > PostGIS 2.1 > > I managed to make them all hear each other following this instructions : > http://resources.arcgis.com/en/help/main/10.2/index.html#//002p000000t4000000 > Data is loaded from ArcGIS with the "Import feature class (single)" > with the "PG_Geometry" configuration keyword in Geodatabase Settings. > With ArcGIS I can connect, view, edit and save the data stored in the > "esrified" PostgreSQL/PostGIS database tables. > > Unfortunately, when I try to do the same thing in QGIS i get an error > message : > "Errors: ERROR: 1 feature(s) not added. > > Provider errors: > > PostGIS error while adding features: ERROR: column "shape" is of type > geometry but expression is of type st_geometry" > > On the other hand, I tried to do the same thing with UDIG and everything > works perfect. > > > I assume that the issue in QGIS is something about what Birgit mentioned : > > "If ArcGIS writes geometries into the PostgreSQL database it names the > geometry column as "shape" with the datatype "geometry" > > > Any ideas ? > > Adrian > > > > > > > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
