[Qgis-developer] postgres provider refactoring

[Jürgen E. Fischer]

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 <jef at 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

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502