[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Settings changed) made by michaudm You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_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: Closed 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=detailatid=679906aid=3519933group_id=118054 -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
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=detailatid=679906aid=3519933group_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=detailatid=679906aid=3519933group_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
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
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=detailatid=679906aid=3519933group_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-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=detailatid=679906aid=3519933group_id=118054 -- How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Comment added) made by jratike80 You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_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: 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=detailatid=679906aid=3519933group_id=118054 -- How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Comment added) made by edso You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_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: Open Resolution: None 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: 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=detailatid=679906aid=3519933group_id=118054 -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Tracker Item Submitted) made by You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_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: Open Resolution: None Priority: 5 Private: No Submitted By: https://www.google.com/accounts () 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 -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_id=118054 -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
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=detailatid=679906aid=3519933group_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: Open Resolution: None 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-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=detailatid=679906aid=3519933group_id=118054 -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
[JPP-Devel] [ jump-pilot-Bugs-3519933 ] PostGIS 'SAVE DATASET AS' write error
Bugs item #3519933, was opened at 2012-04-20 12:42 Message generated for change (Comment added) made by mentaer You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=679906aid=3519933group_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: Open Resolution: None 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: 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=detailatid=679906aid=3519933group_id=118054 -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 ___ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
