Bug report #153

Last column of Postgis table is missing

Added by Redmine Admin over 14 years ago. Updated about 11 years ago.

Status:Closed
Priority:Low
Assignee:Gavin Macaulay -
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:10212

Description

When opening the attribut table of a postgis layer the last column of the postgis table is empty.
After identifying the same object with the identify tool, the column does not appear.

example.zip (150 KB) anonymous -, 2006-06-26 12:11 AM

History

#1 Updated by Gavin Macaulay - over 14 years ago

Works for me. Can you provide some details on the table definition and an example of some of the data in it?

#2 Updated by Redmine Admin over 14 years ago

The file example.zip contains two tables. The table good_col.sql creates a table public.test and was created by QGIS. At this table everything works fine. The other table bad_col.sql will create a table public.geotope. This table was created by shp2pgsql and later some columns were added. At this table the content of the last column is missing.

#3 Updated by Gavin Macaulay - over 14 years ago

Got it - I can now reproduce the problem. Will try to fix it now...

#4 Updated by Gavin Macaulay - over 14 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

Fixed in SVN c8e57255 (SVN r5553).

Actual problem was with tables where the geometry column was not the last column in the table

#5 Updated by Redmine Admin over 14 years ago

  • Status changed from Closed to Feedback
  • Resolution deleted (fixed)

For me it doesn't work. There are much more empty columns than before. All columns right of the geometry column are not shown.

#6 Updated by Gavin Macaulay - over 14 years ago

Oh dear. I'll have another go at fixing it :)

#7 Updated by Gavin Macaulay - over 14 years ago

  • Status changed from Feedback to Closed
  • Resolution set to fixed

Should be fixed in SVN 814974bf (SVN r5554). I'll be bold and close the bug again, confident that the bug is fixed this time:)

#8 Updated by Redmine Admin over 14 years ago

Yep! Now it looks to be fixed. Thank you very much.

#9 Updated by Anonymous about 11 years ago

Milestone Version 0.8 deleted

Also available in: Atom PDF