Feature request #9159

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

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

Status:Open
Priority:Normal
Assignee:-
Category:DB Manager
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:17792

Description

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.

History

#1 Updated by Giovanni Manghi about 3 years ago

  • Easy fix? set to No

Also available in: Atom PDF