Consideration
When previewing a PostGIS table in ArcGIS after creating an FME connection to it, one of the following symptoms may appear:
- A message stating "The current selection cannot be displayed as a table"
- An empty table
- An error about a numeric index
Why This Happens
ArcGIS requires a unique integer field to display a PostGIS table. If the table written by FME does not include one, ArcGIS cannot render it correctly.
How to Resolve It
There are two ways to resolve this.
Option 1: Create a spatial index using a SQL statement
Use a SQL statement to create a spatial index on the table. See the Welcome to ArcGIS Data Interoperability documentation for the exact commands.
Option 2: Configure the destination schema in FME Form
In the PostGIS writer destination schema, set the target field to type int4 and set its Index to PRIKEY. If the features do not already have unique integer values, add a Counter transformer upstream to generate them.