Bug report #16253

Issues with Postgis table having timestamp as primary key

Added by Kai Borgolte over 2 years ago. Updated 9 months ago.

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".

qgistest.zip - PostgreSQL plain dump of table qgistest (402 KB) Kai Borgolte, 2017-03-01 04:36 AM

History

#1 Updated by Giovanni Manghi over 2 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 2 years ago

Is this OK? I didn't edit schema and owner.

#3 Updated by Kai Borgolte over 2 years ago

Please reopen this ticket, I cannot change status.

#4 Updated by Giovanni Manghi over 2 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 2 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 2 years ago

  • Regression? set to No
  • Easy fix? set to No

#7 Updated by Giovanni Manghi 9 months 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 9 months 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 9 months ago

  • Affected QGIS version changed from master to 3.6.0

Also available in: Atom PDF