Good morning Michaël,
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.
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".
3. The tablenames in the ComboBox for the table are not in alphabetic order.
4. The tablenames in the ComboBox for the table are appears twice or
thrice after testing with various names.
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.
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
