<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#000000" text="#ffffff">
The problem:<br>
Missing primary key column in postgresql table imported into Quantum
GIS.<br>
<br>
Details:<br>
43,000 object database created using Windows XP 32 bit, postgresql
8.4, postgis 1.4, Quantum GIS 1.5.<br>
Daily backups using pgadmin.<br>
Several db restores were performed on the XP system for various
reasons (one time was to recover from a lightning strike). Restored
data was good and project continued with no problems.<br>
Recently upgraded to Windows 7 64 bit to be current and take
advantage of the increased memory available.<br>
Installed the same software as above.<br>
The data in postgresql seems ok and can be manipulated normally -
copied, pasted, deleted.<br>
Importing a table into Qgis 1.5 or 1.6 results in layer with the
primary key column missing. The data can't be manipulated
completely. The table can be added to but deletions can't be
performed. The primary key is gid, integer.<br>
<br>
Corrective actions thus far:<br>
Reloaded software many times giving great attention to the details
of installation. Examined the data in pgadmin for anomalies. Nothing
apparent. All seems correct. Posted to Quantum GIS mailing list.
Nothing there.<br>
<br>
Expected resolution:<br>
Barring solution from mailing list suggestions, reinstall on Windows
XP 32 bit and continue with memory limitations as before. (Extra
memory desired to make very large format high-resolution prints).<br>
<br>
</body>
</html>