Feature request #9159
[dbmanager] Option to attempt to add entry in geometry_columns for postgis tables
|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.