Opened 18 years ago

Closed 18 years ago

Last modified 15 years ago

#153 closed bug (fixed)

Last column of Postgis table is missing

Reported by: horst.duester@… Owned by: g_j_m
Priority: critical: causes crash or data corruption Milestone:
Component: Data Provider Version: Trunk
Keywords: Cc:
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: no

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.

Attachments (1)

example.zip (150.0 KB ) - added by anonymous 18 years ago.

Download all attachments as: .zip

Change History (10)

comment:1 by g_j_m, 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?

by anonymous, 18 years ago

Attachment: example.zip added

comment:2 by horst.duester@…, 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.

comment:3 by g_j_m, 18 years ago

Owner: changed from gsherman to g_j_m
Platform: RedHatAll
Type: defectbug

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

comment:4 by g_j_m, 18 years ago

Resolution: fixed
Status: newclosed

Fixed in SVN r5552.

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

comment:5 by horst.duester@…, 18 years ago

Resolution: fixed
Status: closedreopened

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

comment:6 by g_j_m, 18 years ago

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

comment:7 by g_j_m, 18 years ago

Resolution: fixed
Status: reopenedclosed

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

comment:8 by horst.duester@…, 18 years ago

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

comment:9 by (none), 15 years ago

Milestone: Version 0.8

Milestone Version 0.8 deleted

Note: See TracTickets for help on using tickets.