Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Comment added) made by michaudm You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=679906&aid=3519933&group_id=118054
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: OpenJUMP - Menu - Layer Group: MacOSX Status: Pending Resolution: Fixed Priority: 5 Private: No Submitted By: Eric Jarvies () Assigned to: Nobody/Anonymous (nobody) Summary: PostGIS 'SAVE DATASET AS' write error Initial Comment: When attempting to save an edited PostGIS layer, it fails, throwing the error as seen in the screenshot attachment. I am connecting to a PostgreSQL 9.1/PostGIS 2.x database table. I took a local shapefile layer that has the example same schema as does have the remote PostGIS layer, and I copied a feature from this local shapefile layer, and pasted it into the remote PostIGS layer, and then attempted to save it, at which pont I receive this error. Thanks, Eric Jarvies ---------------------------------------------------------------------- >Comment By: michael michaud (michaudm) Date: 2012-11-10 05:11 Message: -1 was the default srid for PostGIS 1.x and at that time, 0 was invalid. 0 is the default srid for PostGIS 2.x (coming from SQL-MM standard) and -1 seems to be converted into 0 by AddGeometryColumn function. My understanding is that the specification described on Spatialite 4.0 page does not apply to PostGIS 2.x. Waiting from an answer from PostGIS list By the way, the new PostGIS Writer can read/write in both PostGIS versions. ---------------------------------------------------------------------- Comment By: Jukka Rahkonen (jratike80) Date: 2012-09-22 07:53 Message: Hi, Perhaps PostGIS 2.x is implementing the same change than Spatialite 4.0? SRID=-1 Undefined - Cartesian SRID=0 Undefined - Geographic Long/Lat See https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0 Unfortunately change is reflecting an ISO standard which is not available without paying for it. ---------------------------------------------------------------------- Comment By: michael michaud (michaudm) Date: 2012-09-22 07:32 Message: Should be fixed. 0 is not a valid srid for PostGIS. In the new writer, -1 is used as default SRID instead of 0. I set the status to pending before closing it definitively by the end of september. ---------------------------------------------------------------------- Comment By: ede (edso) Date: 2012-04-21 02:14 Message: does not look like a openjump issue on the first look. it pretty clearly points out "invalid SRID" so it would be worth checking this out. does loading postgis layer, edit it and save it work flawlessly? please answer michael's questions below as well. ede ---------------------------------------------------------------------- Comment By: mentaer (mentaer) Date: 2012-04-20 15:43 Message: I wrote in my notes for OJ Horae that saving to a file under MacOSX does work with OJ 1.5.x - but not to PostGIS. So it might be that this is a MacOSX specific issue??? ---------------------------------------------------------------------- Comment By: michael michaud (michaudm) Date: 2012-04-20 14:31 Message: Eric, Can you confirm : - that you are using PostGIS 1.5.0 - that you are trying to save a layer loaded from postgis not the one loaded from the shapefile Can you please tel me exactly the options used in the database connexion panel (as the message you get should only happen if you try to create a new table) Can you also tel me if your postgis table has a reference in the geometry_columns table, what is its srid there, and what is the srid in your OpenJUMP remote layer (Layer > Change the SRID) Thanks for your help ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=679906&aid=3519933&group_id=118054 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel