I am attempting to write from a WFS FeaturerReader directly to a FeatureWriter, using the tip outlined in this post:
https://knowledge.safe.com/questions/69654/writing-table-with-featurereader-featurewriter-pro.html
This works for some datasets, but when I try to use a particular dataset, I get an error message:
Bulk copy failed on table 'public.road_works_line_temp' using delimiter ':'. Error was 'ERROR: extra data after last expected column CONTEXT: COPY road_works_line_temp, line 1: "NULL:featureMembers:rwe_line.143236:143236:Sporting/social event:NULL: road closed:NULL:Pending:NULL..."'
The wfs url is
The feature type that fails is rwe_line (rwe_point also fails). If I use a different data set from the same service (e.g. erc_line or erc_point), the import process works without any problems.
From the error message, it looks like something is going wrong with the colon delimiter.
Could anyone suggest a fix for this issue.
Best answer by jkr_wrk
View original