Skip to main content
  • EN

Hi,

In my Postgres database there is one field created directly in database called 'code'.

This field is auto increment.

How I inform to FME that this field exist and none value can be recorded by FME.

I tried record my data without this filed in FME but the ERROR was showed for me.

thank´s

The PostgreSQL writer should be able to insert records which don't have the 'code' attribute (serial type = auto increment field) into the existing table.

Could you please post the logged error messages? Logged messages are important to know what happened, and also there could be a hint for resolving the issue.

The PostgreSQL writer should be able to insert records which don't have the 'code' attribute (serial type = auto increment field) into the existing table.

Could you please post the logged error messages? Logged messages are important to know what happened, and also there could be a hint for resolving the issue.

You can import the schema from the existing table to generate a writer feature type, when adding the writer.

 

Then, the writer feature type containing a serial type field (named 'code' in this example) looks like this.

The PostgreSQL writer should be able to insert records which don't have the 'code' attribute (serial type = auto increment field) into the existing table.

Could you please post the logged error messages? Logged messages are important to know what happened, and also there could be a hint for resolving the issue.

Unfortunately there is no message error. Only the auto increment filed show duplicated.

 

 

You can import the schema from the existing table to generate a writer feature type, when adding the writer.

 

Then, the writer feature type containing a serial type field (named 'code' in this example) looks like this.

I think that your answer help me completly. Thank´s

 

 

Is the name of your sequence defined in the following way: [table_name] _ [field] _seq? If so, FME will automatically recognize the serial type and you will be able to remove the column for Postgresql to fill it automatically.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
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.