span8
span4
span8
span4
An error message similar to one of the examples below is received:
"Error executing SQL command ('select * from "table_name" where false limit 0'): 'ERROR: current transaction is aborted,commands ignored until end of transaction block'"
"Error executing SQL command ('SELECT f_table_name,f_geometry_column,coord_dimension,srid,type FROM geometry_columns WHERE f_table_schema = 'schema_name' AND f_table_name = 'table_name''): 'ERROR: permission denied for relation geometry_columns'Writer failed in write() call Writer failed in write() call f_21(CreationFactory): Writer failed in write() call"
Users may not have permission to access the reserved tables that PostGIS requires,specifically the view geometry_columns.The PostGIS writer expects to be able to read the geometry_columns metadata view to determine how to write the spatial data.
Issue the following statement in the PostGIS database:
GRANT SELECT ON public.geography_columns TO PUBLIC ;
Converting to PostGIS: Create,Drop or Truncate a Table
Converting to PostGIS: Write to an Existing Table
Viewing and Inspecting PostGIS Data
Tutorial: Getting Started with PostGIS and PostgreSQL
FME is loading features with invalid geometries into my Database
Converting from PostgreSQL to MapInfo (Non-Spatial to Spatial)
Performing spatial queries on database tables using the FeatureReader
Join CSV File to a Database Table with the DatabaseJoiner
Updating Databases: Filtering Features to Set Operation Type
© 2019 亚搏在线Safe Software Inc |Legal