[Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0

[Andreas Neumann]

Hi Chris,

That's true - starting from Postgis 2.0, geometry_columns is a view in 
the public schema.

Did you check if that view exists and if the view contains an entry for 
your spatial table?

Also make sure, when importing from FME, that you restrict your geometry 
type to either POINT, POLYGON, LINESTRING, COMPOUNDCURVE or the MULTI 
versions. QGIS likes a single geometry type per table, while Postgis 
would permit to store mixed geometry types in the same geometry column.

Maybe you did not specify this geometry type restriction when importing 
your data with FME.

Andreas

On 05.02.2016 13:33, Chris Buckmaster wrote:
>
> Hi
>
> I have been using FME to load some data into PostGIS and view it in 
> QGIS 2.12.3.
>
> I am finding that when accessing the data in DB Manager, I get a 
> warning that says ‘There is no entry in geometry_columns!’.
>
> On asking another user they mentioned that the geometry columns table 
> was removed in PostGIS 2.0, so my question is, is this a known issue / 
> bug within QGIS, or is it the way in which I am storing my data? Just 
> wondering if this will be looked at in future QGIS versions.
>
> Thanks, Chris
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160205/9356b61f/attachment.html>