[postgis-users] PostGIS layer not rendering

[ahmed at elegantdesigns.ca]

Dear List,

After doing some query analysis, series of inserts and joins, then
vaccuming the layer, QGIS fails to render a layer.
The only way i can show the layer is if i save it as a shp file, then
convert back to postgis with spit.

note that the layer also fails to open in udig.

Any ideas on what could be causing this?