Skip to main content
Solved

NITF to PostGIS errors

  • March 15, 2018
  • 2 replies
  • 24 views
Y

I am getting the following error,when trying to write all the NITF attributes to the PostGIS table.

Bulk copy failed on table 'public.EGPL' using delimiter ':'. Error was 'ERROR: value too long for type character varying(4)

CONTEXT: COPY EGPL, line 1, column nitf_fhdr: "NITF02.00"

'

A fatal error has occurred. Check the logfile above for details

... Last line repeated 2 times ...

FME Session Duration: 3.2 seconds. (CPU: 2.0s user, 0

Best answer by david_r

Looks like FME may have issues with the automatic writer schema definition for this format. Try manually expanding the data type for the "nitf_fhdr" attribute, e.g.

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.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • March 15, 2018

Looks like FME may have issues with the automatic writer schema definition for this format. Try manually expanding the data type for the "nitf_fhdr" attribute, e.g.

Y
  • ygutfreund
  • Author
  • March 16, 2018

Looks like FME may have issues with the automatic writer schema definition for this format. Try manually expanding the data type for the "nitf_fhdr" attribute, e.g.

thanks very much

 

 

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.