Hi Uwe,
Thanks for the test !
> thank you for the new option "Replace all features from table".
> There are still some problems with the plugIn.
> I tested it with Version 20121203 snapshot rev.3099:
>
> 1. If you save a layer to PostGIS with a table name with capital letters
> ("ABC") and you save the project and open it again the layer is empty.
OK, I'll check that. Note that to simplify, I had always considered
table names and column
names as case sensitive, as it was quite complicated to manage both case
insensitive and
case sensitive names.
> 2. If you save the layer "New" to PostGIS with a different tablename
> than the layername with small letters ("abc") and you save the project
> and reopen it you see the geometry but the layername is the old one
> ("New") and not "abc".
Bad, I'll check that.
> 3. The tablenames in the ComboBox for the table are not in alphabetic order.
OK, could be improved easily.
> 4. The tablenames in the ComboBox for the table are appears twice or
> thrice after testing with various names.
OK, could also be improved easily
> 5. The "Replace all features from table" does not work
> if the table does not exist. The old plugIn tested if the
> table exist and create a new table if not.
OK, as the create new table option exist, I'll consider that as a possible
improvement, but will not give it the same priority as your other remarks.
Thanks A LOT for your tests.
Michaël
>
> Regards
>
> Uwe
>
> Am 02.12.2012 19:10, schrieb Michaël Michaud:
>> Hi Uwe, PostGIS users,
>>
>>>> I let 4 options in the PostGIS writer
>>>> - create / overwrite : copy the entire layer content in the db
>>> (remove the db table first if it exists)
>>>
>>> Please do not remove the table in the option "overwrite"
>>> because you delete the constraints too.
>>> Please use DELETE FROM tableName to delete all rows
>>> but to keep the constraints.
>> I added a 5th option to get this behaviour in the Save as PostGIS table
>> plugin. Please test and report.
>> (I used TRUNCATE instead of DELETE, let me know if there is any plus to
>> use DELETE)
>> to test it, use revision r2092 or more in
>> https://sourceforge.net/projects/jump-pilot/files/OpenJUMP_snapshots/
>>
>> There has been much work on the PostGIS related plugins since version 1.4.
>> It is still not complete and it is still difficult to work in a
>> collaborative way on a single big database,
>> but hopefully, the set of new capabilities is consistent enough for the
>> upcoming OpenJUMP release.
>>
>> I added some information in the wiki :
>> https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=Working_with_Databases
>>
>>
>> From my point of view, the only missing features for OJ 1.6 is now
>> tests and documentation ;-)
>>
>> Michaël
>>
>>
>>> Uwe
>>>
>>>
>>> Am 20.11.2012 09:20, schrieb Michaël Michaud:
>>>> Hi Uwe,
>>>>> to insert rows to an existing table (with primary keys)
>>>>> out of OpenJUMP can cause problems if the table is very large.
>>>>> Maybe you have duplicated keys or the table is so large that
>>>>> it costs too much time to insert rows into an existing table.
>>>> I let 4 options in the PostGIS writer
>>>> - create / overwrite : copy the entire layer content in the db (remove
>>>> the db table first if it exists)
>>>> - insert : insert all features from the layer into the table without
>>>> using keys,
>>>> and without removing existing record from the db
>>>> - update : insert/update features using an identifier
>>>> - update with delete : same as previous, but authorizing deletion
>>>>
>>>> I think what you want to do is the first option. Isn't it ?
>>>>
>>>> On the other hand, splitting very large tables to be able to update
>>>> them is
>>>> not always an option. OpenJUMP user is not supposed to be the database
>>>> administrator. So ther option can be useful too.
>>>>
>>>> Michaël
>>>>
>>>> I prefer an other way:
>>>>> Loading the whole table to OpenJUMP.
>>>>> *No* limit, maybe to 100000 rows, or so.
>>>>> Why a limit? This can cause errors if the table has more than 100000
>>>>> rows.
>>>>> If the table is too large, the user has to split it.
>>>>> Then you can edit the table with OJ and after that you can write the
>>>>> whole layer back to the database
>>>>> (with delete from tablename and then insert ...).
>>>>> This is very quick!
>>>>>
>>>>>
>>>>> Regards
>>>>>
>>>>> Uwe
>>>>>
>>>>>
>>>>> Am 17.11.2012 19: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
>>>>>>
>>>>>
>>>
> ------------------------------------------------------------------------------
> Keep yourself connected to Go Parallel:
> BUILD Helping you discover the best ways to construct your parallel projects.
> http://goparallel.sourceforge.net
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
BUILD Helping you discover the best ways to construct your parallel projects.
http://goparallel.sourceforge.net
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
