Bug report #153
Last column of Postgis table is missing
| 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.
History
#1
Updated by Gavin Macaulay - almost 18 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 almost 18 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 - almost 18 years ago
Got it - I can now reproduce the problem. Will try to fix it now...
#4
Updated by Gavin Macaulay - almost 18 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 almost 18 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 - almost 18 years ago
Oh dear. I'll have another go at fixing it :)
#7
Updated by Gavin Macaulay - almost 18 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 almost 18 years ago
Yep! Now it looks to be fixed. Thank you very much.
#9 Updated by Anonymous over 14 years ago
Milestone Version 0.8 deleted