span8
span4
span8
span4
Unexpected errors are received when connecting to PostGIS and PostGIS Raster tables that appear to show in the tablelist.
If the permissions on the metadata tables are not set correctly certain users may be unable to query these tables from FME,even though these tables may show up in the table list.These tables are usually in the "PUBLIC" schema,however certain users may not have proper access to them.This can lead to error messages when attempting to read from or write to spatial or raster tables.
A common example of this error is: Error was 'ERROR: Geometry SRID (900914) does not match column SRID (XXXX)...'.This error occurs when there is no match in the PostGIS spatial reference column for the coordinate system of the data being written.
If FME cannot find a matching coordinate system,it will try to insert a new one into the spatial_ref_sys table.However,if the user logged in doesn't have write permissions for the spatial_ref_sys table,FME cannot do this.
The following commands can be run to correct this:
GRANT ALL ON TABLE public.geometry_columns TO PUBLIC
GRANT ALL ON TABLE public.spatial_ref_sys TO PUBLIC
GRANT ALL ON TABLE public.raster_columns TO PUBLIC
GRANT ALL ON TABLE public.raster_overviews TO PUBLIC
See this article about thesearch pathfor tables that are not showing up in the table list.
Viewing and Inspecting PostGIS Data
Converting to PostGIS: Write to an Existing Table
Performing spatial queries on database tables using the FeatureReader
Converting to PostGIS: Create,Drop or Truncate a Table
Let the Database Do the Work: Reading
Creating a Polygon from Line Segments
Changing Raster Values by Geographic Feature
Executing SQL commands within a workspace using the SQLExecutor
© 2019 亚搏在线Safe Software Inc |Legal