[Qgis-developer] postgres provider refactoring

[Andreas Neumann]

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

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland