Hexagon Geospatial
MENU

Support GeoMedia

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Reply
Frequent Contributor
Posts: 84
Registered: ‎01-14-2018

Writing text feature into postgis

Dear all,

 

I am facing a problem in writing a feature of type "text" into postgis connection,

The error in the GMOTTS.log shows that the valid attributes does not include "Geometry_sk" but accept all other attributes.

 

Hint: I tried writing line and point features on the same connection and there is no problem.

 

Could anyone have a solution to this.

 

Thanks and best regards

Khaled

Staff
Posts: 187
Registered: ‎02-02-2016

Re: Writing text feature into postgis

Based on the description you should be able to avoid the error by omitting the 'Geometry_SK' from the list of source attributes to output using the workflow below:

 

  1. After identifying the source feature class and target connection on the Output To Feature Classes dialog... select the Advanced tab.
  2. On the Advanced tab, select the row in the grid that contains the source feature that results in the error (by clicking the row selector button '>' to the left of the desired row.)
  3. Click the 'Select Source Attributes' button.
  4. On the 'Select Source Attributes' dialog uncheck the 'Geometry_SK' attibute, then click OK on the dialog.
  5. Now click OK on the Output To Feature Classes dialog to proceed with the output of the source feature class. The feature class will be output without the 'Geometry_SK' attribute.

Geometry_SK is a system genereated spatial index column used for Access that is typically hidden. Thus removing it from the list of source attributes will have no ill effect since it is not needed or used for PostGIS.

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.