Hi Jürgen,
Thank you for you work on the PostgreSQL provider.
I have troubles with my views which worked before your refactoring. Now
I can load the layer, but the geometry is not displayed. I can display
the attribute table, but the primary key column is always NULL.
Do you have an idea why my views do not display and why the primary
keys are NULL? I manually selected the pkey column as you described.
Thanks a lot,
Andreas
On Mon, 9 Jan 2012 14:08:02 +0100, Jürgen E. Fischer wrote:
Hi there,
I just commited a larger change to the postgres provider. Mostly
it's
refactoring, but it also contains some features.
You should now be able to use primary keys that are not numeric and
even
primary keys with more that one column should work (not sure how well
the
latter performs).
The handling of the GEOMETRY type was also changed - the geometry
type is now
specified in the layer uri and therefore the automatically generated
subset
string is not necessary anymore. For empty tables you can select
with geometry
type to use.
Views still need numeric primary keys and those need to be selected
when
adding.
Please test and report.
Author: Juergen E. Fischer <j...@norbit.de>
Date: Thu Dec 29 00:02:47 2011 +0100
[FEATURE][API] postgres provider refactoring:
- use m prefix for member variables and s prefix for class
variables
- refactor QgsPostgresProvider::Conn and QgsPostgresConnection to
QgsPostgresConn
- put QgsColumnTypeThread into separate file
- use QgsPostgresConn in QgsPgSourceSelect
- cleaner abort of column type thread (e.g. remove unfinished
columns from
selection list)
- [API] move QgsDbTableModel as QgsPgTableModel to provider
- [FEATURE] support for arbitrary key (including non-numeric and
multi
column)
- [FEATURE][API] support for requesting a certain geometry type
and/or srid
in QgsDataSourceURI
* no more explicit filter strings
* support for empty tables without gemetry_columns entry or
GEOMETRY type.
Jürgen
--
Jürgen E. Fischer norBIT GmbH Tel.
+49-4931-918175-20
Dipl.-Inf. (FH) Rheinstraße 13 Fax.
+49-4931-918175-50
Software Engineer D-26506 Norden
http://www.norbit.de
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
