I have a PostGIS database that uses the PG_Geometry stored in a shape field. This same database is a registered ArcGIS geodatabase. I am able to edit and create features in ArcGIS. I can connect, view and edit attribute data in QGIS, but when I try to create new features I get the error shown below. Ironically it seems that QGIS attempts to use ST_Geometry when writing the data even though the data are stored as PG_Geometry. I am looking for the setting in QGIS that will allow me to write the geometry data using PG_Geometry. Any help is much appreciated.
Could not commit changes to layer drp_occurrence
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 LINE 1: ...atex","dgupdatey","catalognumbernumeric") VALUES (st_geomfro... ^ HINT: You will need to rewrite or cast the expression.