Skip to main content
Question

Storing CAD data in postgres FME Cloud

  • March 24, 2018
  • 1 reply
  • 14 views
G

I am trying to add geometry columns to a postgres instance on FME Cloud and I am getting this error.

ERROR: function addgeometrycolumn(unknown, unknown, unknown, integer, unknown, integer) does not exist LINE 35: SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'...

Here is the select statement, it is from an FMEpedia github project,

SELECT AddGeometryColumn('cad_qa','WATERLINES','geom',2277,'LINESTRING',2);

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • March 24, 2018

Hi @garydlester, most likely you have not yet added PostGIS extensions to the database.
If so, try executing these statements first to add the extensions.

create extension postgis;
create extension postgis_topology;
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.