topic Re: load problem (shape file to postgres) in Talend Studio

load problem (shape file to postgres)

Anonymous — Sat, 16 Nov 2024 12:02:21 GMT

Hello ,
when I try to load a shape file into a potgis DB , this notification appear and I can't understand it .

L'élément du batch 0 INSERT INTO "public"."metadata" ("the_geom","ZID","NAME","ELEV","ICON") VALUES (GeomFromText('POINT (1.43753035191483 43.5925304098064)', 4326),0,'kml_1',0.0,81) a été annulé. Appeler getNextException pour en connaître la cause.

Re: load problem (shape file to postgres)

Anonymous — Mon, 13 May 2013 17:07:02 GMT

Hi, I can't reproduce the issue. Which version of PostGIS are you using ?
Could you also test a simple job with sGeomTxtInput > tPostgresqlOutput and see if you get the same error ?
Thanks.
Francois

Re: load problem (shape file to postgres)

Anonymous — Wed, 12 Jun 2013 09:02:57 GMT

I'm trying to execute this simple job you proposed (sGeomTxtInput > tPostgresqlOutput), but i have the same problem, maybe due to the function "geomfromtext" which should have a prefix "ST_" and the single quotes on "POINT(1 2)".
I'm using Talend DI 5.2.2 and TOS Spatial 5.2.1 on postgresql v 9.2.
Have someone fixed this issue?
Thanks

Re: load problem (shape file to postgres)

Anonymous — Wed, 12 Jun 2013 10:43:37 GMT

After googoling a lot i found the solution.
The problem is related to the version of postgis. In version 2.0 the geomfromtext function has been deprecated and replaced with the suffix "ST_", as well as all the geometry functions.
Then is enough to run the legacy.sql script (located in: C:\ProgramFiles\PostgreSQL\9.2\share\contrib\postgis-2.0) and it work immediately without the need to restart both postgres or TOS.
Bye
Nico
PLEASE SET THE TOPIC AS SOLVED

Re: load problem (shape file to postgres)

Anonymous — Thu, 13 Jun 2013 11:29:41 GMT

Hi NKO,

I have a similar issue,
Can you please send me the legacy.sql script ?
Thanks,
Stefan

Re: load problem (shape file to postgres)

Anonymous — Thu, 13 Jun 2013 11:45:39 GMT

Hi, you can simply find it in your installation directory of Postgis within the PostgreSQL X.X folder.
C: ........ PostgreSQL\9.2\share\contrib\postgis-2.0