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

[Thomas Endres]

I found the information from this link helpful:

<
http://gis.stackexchange.com/questions/157541/postgresql-trouble-editing-points-lines-polygons-in-qgis
>

Altering the geometry type was what fixed things for me.

ALTER TABLE planet_osm_polygon
    ALTER COLUMN way TYPE geometry(MultiPolygon,3857) USING ST_Multi(way);

HTH,
-tom

On Fri, Feb 5, 2016 at 10:11 AM, Chris Buckmaster <
chris.buckmaster at runnymede.gov.uk> wrote:

> 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
>
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> _______________________________________________
> 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/cfaf1dfa/attachment.html>