<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html lang="en">
<head><meta http-equiv="Content-Type" content="text/html;">
<title>Scalix message content</title>
<style type="text/css">
<!--
.Normal { text-align: left; text-indent:0pt; margin-top:0pt; margin-bottom:0pt; font-family: Arial; font-size: 12pt; }
.Default_Paragraph_Font {font-family: Arial; color: Black; background-color: white ; font-size: 12pt; font-weight: normal; font-style: normal; font-variant: normal; vertical-align: normal; text-decoration: none;}
div.ltTOCtitle { font-family: Verdana; font-size: 8pt; font-weight: bold; text-align: center;}
div.ltTOCl1 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:32pt; text-indent:-32pt;}
div.ltTOCl2 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:40pt; text-indent:-32pt;}
div.ltTOCl3 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:48pt; text-indent:-32pt;}
div.ltTOCl4 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:56pt; text-indent:-32pt;}
div.ltTOCl5 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:64pt; text-indent:-32pt;}
div.ltTOCl6 { font-family: Verdana; font-size: 8pt; font-weight: bold; margin-left:72pt; text-indent:-32pt;}
-->
</style>
</head>
<body>
<div class="Normal"><span style='font-size: 10pt; '>Martin</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>I found out further issues
related with OID Indexes (1) and table versioning (2) and one enhancement (3).
</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>1.</span><br><span style='font-size: 10pt; '>When
I select a table with OID index, the meta data Indexes part shows:</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Name
Column(s)</span><br><span style='font-size: 10pt; '>afu_prog05_oid_idx ???
(#-2)</span><br><span style='font-size: 10pt; '>afu_prog05_idx
wkb_geometry</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>A double click on this table
leeds to the following error message:</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Traceback (most recent call
last):</span><br><span style='font-size: 10pt; '> File
"/home/barpadue/.qgis//python/plugins/postgis_manager/ManagerWindow.py", line
439, in editTable</span><br><span style='font-size: 10pt; '> dlg =
DlgTableProperties(self.db, ptr.schema().name,
ptr.name)</span><br><span style='font-size: 10pt; '> File
"/home/barpadue/.qgis//python/plugins/postgis_manager/DlgTableProperties.py",
line 64, in __init__</span><br><span style='font-size: 10pt; '>
self.populateIndexes()</span><br><span style='font-size: 10pt; '> File
"/home/barpadue/.qgis//python/plugins/postgis_manager/DlgTableProperties.py",
line 350, in populateIndexes</span><br><span style='font-size: 10pt; '> cols
+=
self._field_by_number(col).name</span><br><span style='font-size: 10pt; '>AttributeError:
'NoneType' object has no attribute 'name'</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>All tables without OID Index
can be double clicked without any problems.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>2.</span><br><span style='font-size: 10pt; '>*
The schema select box content should be
sortet.</span><br><span style='font-size: 10pt; '>* 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.
</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>3. I would be nice to add a
selected table to Qgis mapcanvas.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Regards</span><br><span style='font-size: 10pt; '>Horst</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>------------------------------------------------</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Dr. Horst
Düster</span><br><span style='font-size: 10pt; '>Stv. Amtschef /
GIS-Koordinator </span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Kanton
Solothurn</span><br><span style='font-size: 10pt; '>Bau- und
Justizdepartement</span><br><span style='font-size: 10pt; '>Amt für
Geoinformation</span><br><span style='font-size: 10pt; '>SO!GIS
Koordination</span><br><span style='font-size: 10pt; '>Rötistrasse
4</span><br><span style='font-size: 10pt; '>CH-4501 Solothurn</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Telefon ++41(0)32 627 25
32</span><br><span style='font-size: 10pt; '>Telefax ++41(0)32 627 22
14</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>mailto:horst.duester@bd.so.ch</span><br><span style='font-size: 10pt; '>http://www.agi.so.ch</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>-----Ursprüngliche
Nachricht-----</span><br><span style='font-size: 10pt; '>Von: Martin Dobias
[mailto:wonder.sk@gmail.com]</span><br><span style='font-size: 10pt; '>Gesendet
am: Mittwoch, 8. Juli 2009 18:45</span><br><span style='font-size: 10pt; '>An:
Andreas Neumann</span><br><span style='font-size: 10pt; '>Cc: qgis-user;
qgis-dev</span><br><span style='font-size: 10pt; '>Betreff: Re: [Qgis-developer]
PostGIS manager v0.5</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>On Wed, Jul 8, 2009 at 3:15
PM, Andreas Neumann<a.neumann@carto.net>
wrote:</span><br><span style='font-size: 10pt; '>> Hi
Martin,</span><br><span style='font-size: 10pt; '>></span><br><span style='font-size: 10pt; '>>
Thank you for this very useful plugin. It feels to me a bit
like</span><br><span style='font-size: 10pt; '>> ArcCatalogue in the ESRI
world.</span><br><span style='font-size: 10pt; '>></span><br><span style='font-size: 10pt; '>>
I have two smaller request if it would be
possible:</span><br><span style='font-size: 10pt; '>></span><br><span style='font-size: 10pt; '>>
For the map preview - could you re-use the QGIS-settings from the
options</span><br><span style='font-size: 10pt; '>> dialogue
regarding:</span><br><span style='font-size: 10pt; '>></span><br><span style='font-size: 10pt; '>>
a) mouse wheel behavior/zooming
and</span><br><span style='font-size: 10pt; '>> b) antialiasing
setting</span><br><span style='font-size: 10pt; '>></span><br><span style='font-size: 10pt; '>>
I don't know if a python plugin can read out these settings? It would
be</span><br><span style='font-size: 10pt; '>> cool if the user would "feel
at home" by getting the same as setting as
in</span><br><span style='font-size: 10pt; '>> regular QGIS.</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Hi Andreas,</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>that's a good idea,
implemented in v0.5.2. Antialiased map looks much better :)</span></div>
<br>
<div class="Normal"><span style='font-size: 10pt; '>Regards</span><br><span style='font-size: 10pt; '>Martin</span><br><span style='font-size: 10pt; '>_______________________________________________</span><br><span style='font-size: 10pt; '>Qgis-developer
mailing
list</span><br><span style='font-size: 10pt; '>Qgis-developer@lists.osgeo.org</span><br><span style='font-size: 10pt; '>http://lists.osgeo.org/mailman/listinfo/qgis-developer</span></div>
</body>
</html>