Feature request #9159

[dbmanager] Option to attempt to add entry in geometry_columns for postgis tables

Added by Nyall Dawson about 10 years ago. Updated over 6 years ago.

Category:DB Manager
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:17792


Dbmanager currently reports a bunch of hints for optimising PostGIS tables, such as missing geometry indexes and tables which are missing entries in geometry_columns. For missing indexes, dbmanager gives the option to create an index. It would be nice to have a similar option for tables which are missing geometry_column entries. This could run the "select populate_geometry_columns('<tablename>'::regclass)" command for the table, and in the case of errors report them back to the user.

I end up running this command a lot while cleaning up PostGIS databases, and in 90%+ of the cases the fix is as simple as running the above SQL command.


#1 Updated by Giovanni Manghi over 6 years ago

  • Easy fix? set to No

Also available in: Atom PDF