I have a problem with PostGIS and a connection to QGIS. I successfully connected to a database on a server but when I try to add a PostGIS Table, I am getting warning symbols next to all my tables. I have permission to all the tables and I am using the latest version of QGIS.

Any hints?

enter image description here

  • 1
    what happens if you manually change the srid, featureid and geometry_type values to the right of the table name? (You may need to scroll to see them). i think qgis relies on the postgis geometry_columns table to pre-populate these, but some tools don't set these up so you have to do this manually. – Steven Kay Dec 17 '18 at 19:51

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.