Skip to main content
Solved

fme-PostGIS-writer with PostgreSQL 10

  • October 26, 2017
  • 3 replies
  • 18 views
M

Moin.

I think there is a problem with the PostGIS-writer and the new PostgreSQL version 10. In PostgreSQL 9.6 there were no problems. Since I installed the version 10 of PostgreSQL (with PostGIS 2.4.1) the following error is thrown:

Error executing SQL command ('SELECT AddGeometryColumn('test', 'myTableName', 'geom', 3034, 'GEOMETRY', 2)'): 'ERROR:  Schema 'test' is not a valid schemaname

"test" is not the schema name, it is the database name. The schema isn't recognized in this command.

Matthias

Best answer by matze

Now i did the upgrate to FME build 17291. There is no more problem.

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.

3 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • October 26, 2017
Hi @matze, when you upgraded did you change your database to an EnterpriseDB PostGIS database?

 

After the error message, do you see the following?

 

CONTEXT: SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6,$7)

 

M
  • matze
  • Author
  • Best Answer
  • November 1, 2017

Now i did the upgrate to FME build 17291. There is no more problem.

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • November 1, 2017

Now i did the upgrate to FME build 17291. There is no more problem.

That's great to hear :)

 

 

Community Stats

32,154
Posts
122,048
Replies
39,812
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.