Bug report #13987
Identify Feature not finding feature
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed/implemented|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||22001|
Using Point data from a Postgresql table, Identify Feature reports "No feature at this position found", despite the cursor been placed in the middle of the symbol. This is regardless of whether the symbol is defined in map units (my preference) or millimiters.
However, using a different layer of point data in the same map (from a Postgresql table), Identify feature works as expected. I have been unable to work out what is the difference is between the two sets of data that would cause Identify Feature work in some cases and not others
#1 Updated by Harry Clarke over 4 years ago
I have identified one difference
Point data from a Table in Postgresql, imported via DB Manager - Identify feature does not work
Point data from a View in Postgresql, imported via Add PostGIS Layers - Identify feature does work
Note I use DB Manager wherever possible, as it is orders magnitude faster to add a Table, than using Add PostGIS Layers. Unfortunatly Views can only be included via the latter functionality.
#5 Updated by Harry Clarke over 4 years ago
Attached is a test project and accompanying SQL to generate the table and view
I have used table and views that already existed, and hence will probably contain lots of extra columns. Identify does not work with the table, but does with the view.
#9 Updated by Giovanni Manghi over 4 years ago
- Target version deleted (
Harry Clarke wrote:
This is frustrating. I do not know what you mean by "...attached sql is not good to restore any data". Please explain precisely what you want me to provide.
trying to restore your tables using the sql you provided it gives and error. If it works with out data/projects it will be good to try with a sample of your data/projects. You did the right thing providing a dump, but restoring does not work (it says there is a relation missing), do just try again.
You should also try master.
Let tag this for 2.14 if there is a regression confirmed (that there is not at the moment, we need more tests).
#10 Updated by Harry Clarke over 4 years ago
- File test_indetify.sql added
Apologies. The tables should be created before the view, and the view was referencing a table/view that it did not need, which is strange given that I had just done a copy from pgAdmin of the relevant tables & view.
Given the size of the tables and the confidentiality of the data, it is not possible a dump of all the data, but the X,Y co-ordinates typically have values of (512500, 123500) from which the_geom is calculated (SQL to generate is enclosed as an example).
ID for the table (that Identify does not work) has a typical value of "DSS0071800003HVE". Changing the ID from a character(16) field to a serial field (i.e. an integer) made no difference.