<div dir="ltr">I found the information from this link helpful:<div><br><div><<a href="http://gis.stackexchange.com/questions/157541/postgresql-trouble-editing-points-lines-polygons-in-qgis">http://gis.stackexchange.com/questions/157541/postgresql-trouble-editing-points-lines-polygons-in-qgis</a>></div><div><br></div><div>Altering the geometry type was what fixed things for me.</div><div><br></div><pre class="" style="margin-top:0px;margin-bottom:1em;padding:5px;border:0px;font-size:13px;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;color:rgb(57,51,24);word-wrap:normal;background-color:rgb(238,238,238)"><code style="margin:0px;padding:0px;border:0px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,sans-serif;white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ALTER</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">TABLE</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> planet_osm_polygon
</span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">ALTER</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">COLUMN</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> way TYPE geometry</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">(</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">MultiPolygon</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">,</span><span class="" style="margin:0px;padding:0px;border:0px;color:maroon">3857</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">)</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;color:rgb(0,0,139)">USING</span><span class="" style="margin:0px;padding:0px;border:0px;color:black"> ST_Multi</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">(</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">way</span><span class="" style="margin:0px;padding:0px;border:0px;color:black">);</span></code></pre><div class="gmail_extra">HTH,</div><div class="gmail_extra">-tom</div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Feb 5, 2016 at 10:11 AM, Chris Buckmaster <span dir="ltr"><<a href="mailto:chris.buckmaster@runnymede.gov.uk" target="_blank">chris.buckmaster@runnymede.gov.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-GB" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Hi Andreas<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Yes it does exist in the geometry column view but the type is listed as GEOMETRY.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">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?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Chris<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">
Qgis-user [mailto:<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Andreas Neumann<br>
<b>Sent:</b> 05 February 2016 12:43<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [Qgis-user] QGIS DB Manager geometry columns issue with PostGIS 2.0<u></u><u></u></span></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi Chris,<br>
<br>
That's true - starting from Postgis 2.0, geometry_columns is a view in the public schema.<br>
<br>
Did you check if that view exists and if the view contains an entry for your spatial table?<br>
<br>
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.<br>
<br>
Maybe you did not specify this geometry type restriction when importing your data with FME.<br>
<br>
Andreas<u></u><u></u></p>
<div>
<p class="MsoNormal">On 05.02.2016 13:33, Chris Buckmaster wrote:<u></u><u></u></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hi<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I have been using FME to load some data into PostGIS and view it in QGIS 2.12.3.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I am finding that when accessing the data in DB Manager, I get a warning that says ‘There is no entry in geometry_columns!’.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Thanks, Chris<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br>
<br>
<br>
<u></u><u></u></span></p>
<pre>_______________________________________________<u></u><u></u></pre>
<pre>Qgis-user mailing list<u></u><u></u></pre>
<pre><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><u></u><u></u></pre>
<pre>List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><u></u><u></u></pre>
<pre>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><u></u><u></u></pre>
</blockquote>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u> <u></u></span></p>
</div></div></div>
</div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div></div></div>