Skip to main content
Question

Geometry in PostGis table

  • February 26, 2019
  • 1 reply
  • 28 views
mr_fme
Enthusiast
Forum|alt.badge.img+9

I'm writing information with geometry in Postgis table. It is currently in UTM, (SA-SIR-22S), before I need reproject for EPSG 4674 (SIRGAS 2000 LL). A failure occurs:

 

The bulk copy failed in the 'public.amb_app' table using the ':' delimiter. Error was' ERROR: new line for relation "amb_app" violates verification constraint "enforce_srid_geom"

CONTEXT: COPY amb_app, line 1: "8.34: 4: 461: 0400046100001: etn.sao francisco (flavio): 010300002042120000010000008503 ... '

A fatal error has occurred. Check the log file above for details

... Last row repeated 2 times ...

 

How to solve this?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • February 27, 2019

You need to verify the SRID specified in the postgis table constraint named 'enforce_srid_geom' and make sure that your FME features are tagged with the exact same coordinate system before they arrive to the writer.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.