Hello!
I have a newly installed PostgreSQL database with a PostGIS extension enabled. Because of licencing consideration we want to migrate our oracle database to this database.
We are using database side bussiness logic in our views, so i want to write directly to the views without success.
- We have Postgresql 12 AND postgresql 16 for compatibility testing
- Every version of FME from 2018-2023 (mainly using 2018 because we have too many scripts to migrate all)
I have tried most of the version combination with the same error every time. This is what im trying:
- Created the table definition with FME
- Based on the created definition created a simple view but the workbench keep dropping this error:
- Invalid PostGIS metadata detected for table 'public.generated_np_node_view'. Attempting to correct and continue
- POSTGIS Writer: Table 'public.generated_np_node_view' does not exist.
The inserting with pgadmin or geoserver works fine, the inserting to directly to the table works fine but thats not are we want. I can insert using the PostgreSQL writer but thats not writing spatial data.
Only the PostGIS writer not working.
Im attaching an example workspace my table declaration and a log file. (in the log file i only run the writed in debug mode)
Tried this topic but didn't worked out.
I hope i wrote clearly, in the last 6 years with FME, this is the first time if a need to ask.
Thank you in advance for your help:
Tamás
