[Qgis-user] PostGIS Query - DB Manager Not Recognizing Geom Column

[Michael Treglia]

Hi All,

I'm running a PostGIS query to create a view, buffering a polygon - viewing
the result in DB Manager, the associated icon, rather than being polygons,
is a question mark, and in the info tab for the layer, I see the warning '
There is no entry in geometry_columns!'

That said, the layer actually displays fine in QGIS, and in the list of
fields, the appropriate column is labeled as Type 'geometry'.

Thus, is this really a problem? And if so, any easy fixes? A sample query
is below:

CREATE OR REPLACE VIEW test.testbuff as
SELECT gid, area_id, st_buffer(testshape.geom, 100)
as geom2 FROM test.testshape where testshape.area_id=100;


Thanks for any suggestions!
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170327/f5a3e0d6/attachment.html>