Hi Jukka, > Dynamic PostGIS layers may be a bit odd for editing. What happens if user has > created some features from a large area and he saves them into an existing > layer when zoomed in to the last new feature. Will the other new features > which are outside the viewport disappear from user until he zooms to the > correct area? You're right, dynamic postgis layers are very interesting but have major drawback. - not only that layer features located outside the view will disappear from the view after a save/reload operation (it maybe surprising, but at least, features are saved in the table) - but if you check the insert/update/delete mode, it may delete all the features from the postgis table except thoses visible in the view (even using a database unique identifier) !
That's one of the reason why I let insert or update without delete modes. The only way I can think of to manage CRUD operations without deleting invisible features is to create transactions containing all user modifications between two save operations. This is a bit more complex than updating the whole layer using identifiers, specialy with dynamic layers. Michaël > > -Jukka- > > > Michaël >> -Jukka Rahkonen- >> ________________________________________ >> Lähettäjä: Stefan Steiniger [sst...@geo.uzh.ch] >> Lähetetty: 17. marraskuuta 2012 21:11 >> Vastaanottaja: OpenJump develop and use >> Aihe: Re: [JPP-Devel] Can not read PostGIS projects >> >> Hi Michael, >> >> sounds reasonable to me. But we would need to add a comment on that... >> When the project is saved, it would mean to send a message to the user >> at save time? >> >> thanks for working on this - on the weekend! >> stefan >> >> Am 17.11.12 15:17, schrieb Michaël Michaud: >>> Hi Uwe, others, >>> >>> I'd like to have PostGIS users feedback about the following question : >>> Save as PostGIS table can save a layer as a new PostGIS table >>> or update an existing PostGIS table with different options. >>> >>> IMHO, only the first option (create new table) should set the postgis >>> table as the new Datasource for the layer (and save it in the project). >>> >>> In other cases, the layer may contain only a few features and >>> the table we connect to maybe a huge table. Setting this huge table >>> as the new datasource may freeze the application. >>> >>> Any comment ? >>> >>> Michaël >>> >>>> Uwe, Landon, >>>> >>>> I had forgotten Uwe's mail, but I now have added a bug report >>>> and will tackle it before 1.6 final release. >>>> >>>> Michaël >>>>> Hi Landon, >>>>> >>>>> no, I got no response. >>>>> >>>>> I tested it now again with the latest nightbuild >>>>> (Version 20121111 snapshot rev.3073), but I have the >>>>> same problem. >>>>> >>>>> Regards >>>>> >>>>> Uwe >>>>> >>>>> Am 12.11.2012 17:26, schrieb Landon Blake: >>>>>> Uwe: >>>>>> >>>>>> Did you ever get a response or a solution to this problem? >>>>>> >>>>>> Landon >>>>>> >>>>>> On Mon, Sep 24, 2012 at 12:00 AM, Uwe Dalluege >>>>>> <uwe.dallu...@hcu-hamburg.de> wrote: >>>>>>> Hi, >>>>>>> >>>>>>> I can not read projects with PostGIS layer. >>>>>>> OJ Version 20120924 snapshot rev.3004 >>>>>>> OS: W7 (64 bit) and XP (32 bit). >>>>>>> >>>>>>> 1. Add A New Layer. >>>>>>> 2. Draw a geometry. >>>>>>> 3. Save the layer to PostGIS with Save Dataset As. >>>>>>> 4. Save Project As... >>>>>>> >>>>>>> 5. When I open the project again the project is empty >>>>>>> and the category System is deleted. >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> Uwe >>>>>>> >>>>>>> ------------------------------------------------------------------------------ >>>>>>> Live Security Virtual Conference >>>>>>> Exclusive live event will cover all the ways today's security and >>>>>>> threat landscape has changed and how IT managers can respond. >>>>>>> Discussions >>>>>>> will include endpoint security, mobile security and the latest in >>>>>>> malware >>>>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>>>>>> _______________________________________________ >>>>>>> Jump-pilot-devel mailing list >>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> ------------------------------------------------------------------------------ >>>>> 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 >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> 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 >>>> >>>> >>> ------------------------------------------------------------------------------ >>> 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 >>> >> ------------------------------------------------------------------------------ >> 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 >> >> ------------------------------------------------------------------------------ >> 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 >> >> > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ > 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 > > ------------------------------------------------------------------------------ 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