[Qgis-user] AW: Re: [Qgis-developer] PostGIS manager v0.5
Martin I found out further issues related with OID Indexes (1) and table versioning (2) and one enhancement (3). 1. When I select a table with OID index, the meta data Indexes part shows: Name Column(s) afu_prog05_oid_idx ??? (#-2) afu_prog05_idx wkb_geometry A double click on this table leeds to the following error message: Traceback (most recent call last): File "/home/barpadue/.qgis//python/plugins/postgis_manager/ManagerWindow.py", line 439, in editTable dlg = DlgTableProperties(self.db, ptr.schema().name, ptr.name) File "/home/barpadue/.qgis//python/plugins/postgis_manager/DlgTableProperties .py", line 64, in __init__ self.populateIndexes() File "/home/barpadue/.qgis//python/plugins/postgis_manager/DlgTableProperties .py", line 350, in populateIndexes cols += self._field_by_number(col).name AttributeError: 'NoneType' object has no attribute 'name' All tables without OID Index can be double clicked without any problems. 2. * The schema select box content should be sortet. * The geometry index and all other indexes of the versionized table should be a patial index with the constaint "where time_end = NULL ". With a partial index you will have huge performance advantages. With the time the amount of archived or historized records will grow up. P.e. one table of our cadastral data contains more than 1 Mio records, but 70 of them are not in production state (end_time <> NULL). With the partial index these records don't exists for Postgres, as the result you do not have any performance problems with your production data. 3. I would be nice to add a selected table to Qgis mapcanvas. Regards Horst Dr. Horst Düster Stv. Amtschef / GIS-Koordinator Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Telefax ++41(0)32 627 22 14 mailto:horst.dues...@bd.so.ch http://www.agi.so.ch -Ursprüngliche Nachricht- Von: Martin Dobias [mailto:wonder...@gmail.com] Gesendet am: Mittwoch, 8. Juli 2009 18:45 An: Andreas Neumann Cc: qgis-user; qgis-dev Betreff: Re: [Qgis-developer] PostGIS manager v0.5 On Wed, Jul 8, 2009 at 3:15 PM, Andreas Neumann wrote: > Hi Martin, > > Thank you for this very useful plugin. It feels to me a bit like > ArcCatalogue in the ESRI world. > > I have two smaller request if it would be possible: > > For the map preview - could you re-use the QGIS-settings from the options > dialogue regarding: > > a) mouse wheel behavior/zooming and > b) antialiasing setting > > I don't know if a python plugin can read out these settings? It would be > cool if the user would "feel at home" by getting the same as setting as in > regular QGIS. Hi Andreas, that's a good idea, implemented in v0.5.2. Antialiased map looks much better :) Regards Martin ___ Qgis-developer mailing list qgis-develo...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] PostGIS manager v0.5
Hello Martin: A few more points you might take into consideration: 1- The "VACUUM ANALYZE" warning appears also for views. That's probably unnecessary. 2- To get the plugin working on windows, the psycopg2 library must be installed. That's available when using the OSGeo4W installer, thru the "Advanced" option. It's worth mentioning this (somewhere...). 3- Is it possible to maintain the state of the Table of Contents list of schemas and tables from session to session? It's a minor point, but with a long list of tables, this might add a bit to usability. On the whole, this plugin is a substantial boost for QGIS-PostGIS setups. Thanks, Micha Martin Dobias wrote: Hi all, I'd like to announce new version of PostGIS Manager - already in the repositories (both in mine and in contributed plugins at pyqgis.org): - shows triggers and rules, able to delete or enable/disable them - faster GUI as it loads only content for current tab (and not all of them as before) - geometry processing - allows you to do area/length calculation and (optionally) set a trigger that updates the field on inserts and updates - table versioning (experimental) - modifies a table so it stores all history of the changes - various updates and bug fixes I've incorporated from the feedback I've got Any feedback is welcome as usual :) Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This mail was received via Mail-SeCure System. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] PostGIS manager v0.5
Hi Martin, Thank you very much for your very quick reactions/implementations! Andreas Martin Dobias wrote: On Wed, Jul 8, 2009 at 3:15 PM, Andreas Neumann wrote: Hi Martin, Thank you for this very useful plugin. It feels to me a bit like ArcCatalogue in the ESRI world. I have two smaller request if it would be possible: For the map preview - could you re-use the QGIS-settings from the options dialogue regarding: a) mouse wheel behavior/zooming and b) antialiasing setting I don't know if a python plugin can read out these settings? It would be cool if the user would "feel at home" by getting the same as setting as in regular QGIS. Hi Andreas, that's a good idea, implemented in v0.5.2. Antialiased map looks much better :) Regards Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] PostGIS manager v0.5
On Wed, Jul 8, 2009 at 3:15 PM, Andreas Neumann wrote: > Hi Martin, > > Thank you for this very useful plugin. It feels to me a bit like > ArcCatalogue in the ESRI world. > > I have two smaller request if it would be possible: > > For the map preview - could you re-use the QGIS-settings from the options > dialogue regarding: > > a) mouse wheel behavior/zooming and > b) antialiasing setting > > I don't know if a python plugin can read out these settings? It would be > cool if the user would "feel at home" by getting the same as setting as in > regular QGIS. Hi Andreas, that's a good idea, implemented in v0.5.2. Antialiased map looks much better :) Regards Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] PostGIS manager v0.5
Hi Martin, Thank you for this very useful plugin. It feels to me a bit like ArcCatalogue in the ESRI world. I have two smaller request if it would be possible: For the map preview - could you re-use the QGIS-settings from the options dialogue regarding: a) mouse wheel behavior/zooming and b) antialiasing setting I don't know if a python plugin can read out these settings? It would be cool if the user would "feel at home" by getting the same as setting as in regular QGIS. Thanks, Andreas On Tue, July 7, 2009 11:05 pm, Martin Dobias wrote: > Hi all, > > I'd like to announce new version of PostGIS Manager - already in the > repositories (both in mine and in contributed plugins at pyqgis.org): > - shows triggers and rules, able to delete or enable/disable them > - faster GUI as it loads only content for current tab (and not all of > them as before) > - geometry processing - allows you to do area/length calculation and > (optionally) set a trigger that updates the field on inserts and > updates > - table versioning (experimental) - modifies a table so it stores all > history of the changes > - various updates and bug fixes I've incorporated from the feedback I've > got > > Any feedback is welcome as usual :) > > Martin > ___ > Qgis-developer mailing list > qgis-develo...@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] AW: Re: [Qgis-developer] PostGIS manager v0.5
Hi Martin I can't send you the contents of the metadata tab. The error message arises when I click on the table. Regards Horst Dr. Horst Düster Stv. Amtschef / GIS-Koordinator Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Telefax ++41(0)32 627 22 14 mailto:horst.dues...@bd.so.ch http://www.agi.so.ch -Ursprüngliche Nachricht- Von: Martin Dobias [mailto:wonder...@gmail.com] Gesendet am: Mittwoch, 8. Juli 2009 12:02 An: Düster Horst Cc: qgis-developer; qgis-user Betreff: Re: [Qgis-developer] PostGIS manager v0.5 On Wed, Jul 8, 2009 at 8:53 AM, Düster Horst wrote: > Hi Martin > Great enhancements of the plugin thank you very much. I have some feedback: > 1. The schema list in Database view should be sorted > 2. On some tables (not in all cases) I do get the following error message: > [...] > "/home/barpadue/.qgis//python/plugins/postgis_manager/MetadataBrowser.py ", > line 249, in showTableInfo > keys += self._field_by_number(key, fields).name > AttributeError: 'NoneType' object has no attribute 'name' Hi Horst, both are fixed in 0.5.1. Anyway I don't really understand the reason of 2nd problem - it seems like there's a constraint on column that doesn't exist... or something goes wrong in the plugin :-) Could you post me the contents of the metadata tab for such table(s)? Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: [Qgis-developer] PostGIS manager v0.5
On Wed, Jul 8, 2009 at 8:53 AM, Düster Horst wrote: > Hi Martin > Great enhancements of the plugin thank you very much. I have some feedback: > 1. The schema list in Database view should be sorted > 2. On some tables (not in all cases) I do get the following error message: > [...] > "/home/barpadue/.qgis//python/plugins/postgis_manager/MetadataBrowser.py", > line 249, in showTableInfo > keys += self._field_by_number(key, fields).name > AttributeError: 'NoneType' object has no attribute 'name' Hi Horst, both are fixed in 0.5.1. Anyway I don't really understand the reason of 2nd problem - it seems like there's a constraint on column that doesn't exist... or something goes wrong in the plugin :-) Could you post me the contents of the metadata tab for such table(s)? Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user