Question

How to write a PostgreSQL table with an generated column?

  • 31 August 2021
  • 2 replies
  • 15 views
dhaulagiri
Rank
Badge +4

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

2 replies

dhaulagiri
Rank
Badge +4

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...

danilo_fme
Rank
Userlevel 4
Badge +30

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

28,724
Posts
109,518
Replies
36,564
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.