Bug report #16253
Issues with Postgis table having timestamp as primary key
Status: | Open | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | Data Provider/PostGIS | ||
Affected QGIS version: | 3.6.0 | Regression?: | No |
Operating System: | Easy fix?: | No | |
Pull Request or Patch supplied: | No | Resolution: | |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 24163 |
Description
I tried to use a QGIS point layer from a PostgreSQL 9.6 table, which contains a modified GPS track. The table uses field "time" (timestamp without time zone) as primary key.
I see two issues regarding the attribute table:
1. The attribute table shows ERROR values in all fields. It seems this applies to
rows which don't fit into the attribute table row cache (default 10000 rows).
2. Klicking on "Pan map to the selected rows" tool button gives message "Cannot pan to selected feature(s): Geometry is NULL".
History
#1
Updated by Giovanni Manghi over 7 years ago
- Status changed from Open to Feedback
Can you attach sample data (preferably a dump of the table, or part of it)?
#2
Updated by Kai Borgolte over 7 years ago
- File qgistest.zip added
Is this OK? I didn't edit schema and owner.
#3
Updated by Kai Borgolte over 7 years ago
Please reopen this ticket, I cannot change status.
#4
Updated by Giovanni Manghi over 7 years ago
Redoute Tortenboxer wrote:
Please reopen this ticket, I cannot change status.
the ticket is still open. When I will try the data I will set it again to "open" or leave "feedback" if I need more feedback. Thanks.
#5
Updated by Giovanni Manghi over 7 years ago
- Target version set to Version 3.0
- Affected QGIS version changed from 2.18.4 to master
- OS version deleted (
10) - Operating System deleted (
Windows) - Status changed from Feedback to Open
- Category changed from Attribute table to Data Provider/PostGIS
- Description updated (diff)
#6
Updated by Giovanni Manghi over 7 years ago
- Regression? set to No
- Easy fix? set to No
#7
Updated by Giovanni Manghi over 5 years ago
- Status changed from Open to Feedback
Please check if this issue is still valid on QGIS 3.4.5 or 3.6.
#8
Updated by Kai Borgolte over 5 years ago
- Status changed from Feedback to Open
The issue is still valid with QGIS 3.6.0. One minor change:
2. Klicking on "Pan map to the selected rows" tool button gives message "Cannot pan to selected feature(s) : No extent could be determined.".
#9
Updated by Giovanni Manghi over 5 years ago
- Affected QGIS version changed from master to 3.6.0