If the "create with oid" is set in an earlier version of FME, both desktop and server still reads this. And you now dont have the option to remove it, unless you open the workbench in a earlier version.
I'm using build 20202, and I just noticed cause we migrated to a newer PostGis server version which dont support OIDS. The parameter exists in 2019.2.
Best answer by trentatsafe
Hello @jonathanklarup ,
This is a bug, that I have filed and can be tracked via FMEENGINE-67390. I've added this QA to the issue, and will notify you when it has been addressed! I apologize for the inconvenience.
I believe you can still use OIDs, but you now have to add the OID column manually (or import it from an existing table definition). If you look into the feature type definition, there is an OID data type.
If necessary, you can also upgrade the reader / writer version in FME simply by right-clicking it in the Navigator and selecting Update:
Thanks for your attention, but I might not have been clear in my formulation.
If you check off the "create wit oids" in FME 2019, and you then wanna check it off in 2020 it is not possible.
And depending on PostGis version this can create errors when creating the table, as such:
"Writer failed to create table 'oversigt'. OIDs are not supported for PostgreSQL version 'PostgreSQL 12.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit' (requires lower than PostgreSQL 12)"
I have fixed my problem it was just to make attention to this 😃
+6Hello @jonathanklarup ,
This is a bug, that I have filed and can be tracked via FMEENGINE-67390. I've added this QA to the issue, and will notify you when it has been addressed! I apologize for the inconvenience.
Hello @jonathanklarup ,
This is a bug, that I have filed and can be tracked via FMEENGINE-67390. I've added this QA to the issue, and will notify you when it has been addressed! I apologize for the inconvenience.
Thank you Trent :)
Hello @jonathanklarup ,
This is a bug, that I have filed and can be tracked via FMEENGINE-67390. I've added this QA to the issue, and will notify you when it has been addressed! I apologize for the inconvenience.
I agree with @jonathanklarup , it's a bit annoying to have to go in PG and put OID once a table is created... 😉
