PostGIS Error if Access Not Granted to Geometry Table

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2015.x

Problem

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" 

Cause

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.

Solution

Issue the following statement in the PostGIS database:

GRANT SELECT ON public.geography_columns TO PUBLIC ; 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.