Skip to main content
  • EN

Hello,

FME throws an error when I want to write to a PostgreSQL table that contains a generated column (value calculated from another column). Message: generated columns cannot be used in COPY

Is there any way to ignore this column (by clearing the column from the writer, the error still occurs) or work around this problem?

Thanks for your help

I tried to change bulk insert parameter to no (using INSERT and not COPY) but it returns also an error. I finally find a way: AttributeCreator to create a sql command with INSERT and SQLExecutor.

Hope it will be useful...

I tried to change bulk insert parameter to no (using INSERT and not COPY) but it returns also an error. I finally find a way: AttributeCreator to create a sql command with INSERT and SQLExecutor.

Hope it will be useful...

Nice @dhaulagiri​ 

Reply


Community Stats

30,123
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
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.