Skip to main content
Archived

Enable FeatureWriter to handle tables after the table-name changed

Related products:FME Form
  • September 10, 2019
  • 0 replies
  • 31 views
F

Currently the FeatureWriter for Postgis throws an error under the following situation:

- table with an id-column (as serial) has been created.

- if the table-name will be changed in Postgres, the column-definition of the id-column changes from

"<id> Serial Not NULL"

to

"<id> integer NOT NULL DEFAULT nextval('<old_table_name>_<id>_seq'::regclass),

- while Postgres is able to handle this reference to the old sequence, FME can't and crashes with the errror, that it can't write NULL into a serial id column.

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.

Community Stats

32,749
Posts
124,194
Replies
41,251
Members
Terms & ConditionsAccessibility 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.