Question

PostGreSQL: non-spatial data reader

  • 23 January 2020
  • 2 replies
  • 4 views
J

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!

2 replies

oscard
Rank
Userlevel 2
Badge +19

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

M
Badge +2

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

Reply


Community Stats

28,714
Posts
109,490
Replies
36,561
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.