Skip to main content
Solved

Is it itentionally that "Table Creation Parameter","create with OIDS" in a PostGis FeatureWriter is missing in FME 2020 or is it a bug?

  • September 10, 2020
  • 5 replies
  • 43 views

Forum|alt.badge.img

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.

View original
Did this help you find an answer to your question?

5 replies

david_r
Evangelist
  • September 10, 2020

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:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Updating-Readers-Writers.htm


Forum|alt.badge.img

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 😃


trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • Best Answer
  • October 21, 2020

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.


Forum|alt.badge.img
trentatsafe wrote:

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 :)


aurelienchaumet
trentatsafe wrote:

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings