Feature request #9159
[dbmanager] Option to attempt to add entry in geometry_columns for postgis tables
| 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 over 7 years ago
- Easy fix? set to No