[Qgis-user] QGIS crashes when saving an edited table and retaining old symbology, other attribute table issues
I'm using QGIS 1.3.0 on OS X 10.6.1 (I got the build and dependencies from KyngChaos), and I've had a recurring issue in which when I edit the attribute table for a layer which is stored in PostGIS with the Table Manager plugin, and then "save as" a shapefile, and then tell the plugin yes, I'd like to add the new layer to the TOC, and please retain the old symbology, QGIS crashes. It seems to happen every time. If I don't try and retain the old symbology, it doesn't crash. I have not been editing any columns in the table used to determine how the features display. I've also noticed that often (but not always) when I view the attribute table for a layer, it only displays the first few, or few dozen entries, instead of the entire list of records. I know the records are there, because if I re-sort the table I can see things that weren't displayed before. Seems odd. Another issue: if I'm editing a vector layer, which has only a single field in its attribute table (you can't create one that has no fields), and I create a new feature, and don't enter a value for that one field, then the feature is not saved. I ran into this recently when digitizing features for which I really just wanted a unique ID (like the gid, which is automatically generated) and the geometry. I turned off the attribute table prompt in the main QGIS preferences, and merrily went along my way digitizing, only to realize later that none of those features actually got saved. :( Has anybody else seen these issues? What's the appropriate place to post this kind of thing? I searched in Trac and didn't see these particular problems. Thanks, Zane -- Zane A. Selvans Amateur Earthling http://zaneselvans.org +1 303 815 6866 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Selecting features in attribute table using query builder
>> I'm trying to select a subset of the features in a layer based on some >> values in their attribute table, and I keep getting the following >> error: >> >> syntax error, unexpected COLUMN_REF >> >> The where clause I'm using is: >> >> 2_LIN_ID < 1_LIN_ID >> > Just a shot in the dark: Can column names begin with a digit? You might need > to change to LIN_ID_1 and LIN_ID_2 I had this thought too, but I didn't name the columns. They were automatically generated when I used the "line intersections" tool to create the points shapefile from my digitized linear features. I *can* do a select based on another column though (with a non-numeric first character), so maybe this is the problem, and a bug in the Line Intersections tool? I don't seem to be able to re-name the columns in the attribute table unfortunately (I can see them and their types listed in the "properties" dialog, but can't change them, even when the layer is being edited). I tried adding an "alias" for each of them (LIN_ID_1 and LIN_ID_2) but they don't seem to stick: when I open up the attribute table again, the aliases don't show up, and when I open up the attributes under properties again, the aliases aren't there any more (despite having saved the layer immediately after adding them). So... does anyone have a workaround here? Can I somehow re-name these columns, or create new columns a copy their content in? Or force the "Line Intersections" tool to use particular names for its output columns? Thanks, Zane -- Zane A. Selvans Amateur Earthling http://zaneselvans.org +1 303 815 6866 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Selecting features in attribute table using query builder
Hi all, I'm trying to select a subset of the features in a layer based on some values in their attribute table, and I keep getting the following error: syntax error, unexpected COLUMN_REF At first I thought it was because I was using a shapefile instead of a PostGIS DB (since apparently the query builder only works on features within PostGIS), so I imported the shapefile using SPIT, added the new PostGIS based feature, pulled up the attribute table again, and tried the selection operation, and got the same error. I can't find any reference to this particular error message in the mailing list archives. I'm using the QGIS 1.3.0 build from KyngChaos on OS X 10.6.1 (and all of his supporting framework builds). The where clause I'm using is: 2_LIN_ID < 1_LIN_ID each of 2_LIN_ID and 1_LIN_ID are the names of fields (columns) in the attribute table. They contain integers. The layer is a collection of points, representing the intersections between some lines I digitized, and those fields are the IDs of the lines. Am I just doing something stupid, or is there brokenness here? Thanks for any insight, Zane -- Zane A. Selvans Amateur Earthling http://zaneselvans.org +1 303 815 6866 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user