AW: Re: [Qgis-developer] PostGIS manager v0.5

[Düster Horst]

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 700000
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.duester at bd.so.ch
http://www.agi.so.ch



-----Ursprüngliche Nachricht-----
Von: Martin Dobias [mailto:wonder.sk at 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<a.neumann at carto.net>
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-developer at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20090709/271729b5/attachment.html