[Qgis-user] Strange behaviour importing data from postgis

[Bo Victor Thomsen]

It might be a point/multipoint issue. If your Postgis table contains 
both point and multipoint entries, QGIS will represent the table as 
_two_ tables in the "Add Postgis Layers" dialogue. One table with the 
"point" type and another table with the same name, but with the 
"multipoint" type. The reason for this behaviour it that a QGIS layer 
can only contain _one_ specific type of object. And point and multipoint 
object are different types. Line/Multiline and Polygon/Multipolygon has 
the same issues.

Regards
Bo Victor Thomsen
AestasGIS
Denmark
Den 23-02-2015 kl. 10:25 skrev Igor Sosa Mayor:
> Hi,
>
> I'm starting using QGIS and I found a strange behaviour importing a
> layer from postgis.
>
> I'm doing the following:
> 1. download from openstreetmap a osm file
> 2. import it to postgis with osm2psql
> 3. I add a layer in QGIS using the postgresql import function.
>
> Everything seems to work OK...
>
> BUT: not all points are imported. More or less 30% out of the points is
> not neither in the layer nor in the attribute table. But if I do a query
> on the database the points are there.
>
> Maybe any idea how I could debug this a little better (without error
> messages it is difficult to see the possible issue)...
>
> Many thanks in advance.
>