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

[Chris Buckmaster]

Hi Andreas

Yes it does exist in the geometry column view but the type is listed as GEOMETRY.

This table is being created from a non-spatial SQL Server table, and we use a vertex creator transformer in FME to create the spatial table – we cannot seem to explicitly specify the geometry that the spatial table should be as it is not a spatial layer when imported?

Chris


From: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Andreas Neumann
Sent: 05 February 2016 12:43
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0

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<mailto: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/a1c6d092/attachment.html>