Skip to main content
Question

PostGreSQL: non-spatial data reader

  • January 23, 2020
  • 2 replies
  • 35 views

Hello,

I have FME 2018.1 and PostgreSQL 9.4.

I try to create a reader with non spatial date so I could join them with spatial data but it seems FME can't reader the features in the non-spatial table.

I tried to open it in the Inspector but it doesn't work too:

 

Opening POSTGRES reader for dataset 'cadastre_2019'

PostGIS client encoding: 'UTF8'

PostgreSQL 9.4.0, compiled by Visual C++ build 1800, 64-bit

Successfully closed POSTGRES database reader

Successfully closed POSTGRES database reader

Merged 1 schema features read from 1 datasets into 1 resulting feature types

Saving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'

Finished saving spatial index into file 'C:\\Users\\J\\AppData\\Local\\Temp\\FFS_1579770320565_8204_DATA.fsi'

Removing dataset 'cadastre 2019 [POSTGRES]' from View 1

Successfully closed POSTGRES database reader

The dataset 'cadastre<space>2019' was closed successfully

The 'POSTGRES' reader was destroyed successfully

 

Is anyone had an idea about that?

 

Thanks in advance!

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.

2 replies

oscard
Influencer
Forum|alt.badge.img+22
  • Influencer
  • January 23, 2020

Are you using PostGres o PostGis reader? You should use the PostGres one for non-spatial data


Forum|alt.badge.img+2
  • January 23, 2020

@jennpe It looks like that table is empty. All signs are that FME found the "cadastre 2019" but didn't read any records.

The message: Removing dataset 'cadastre 2019 [POSTGRES]' from View 1 usually means the View was removed because no data was found

In FME Workbench try using the SQLCreator to read the table with a SELECT clause, or check your table in PGAdmin or equivalent.