<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#000000" text="#ffffff">
This WAS a data issue. The solution came from Ben in the PostGIS
mailing list. The gid column used as the primary key was missing
from the geometry table. The solution was to delete the bad primary
key and add the gid column as a serial integer, then set it as the
table's primary key. Everything works. <br>
Thanks to all that responded. Happy New Year. I'll go back to my
dark little room now and be quiet.<br>
<br>
On 1/8/2011 5:16 PM, Byron Como wrote:
<blockquote cite="mid:4D28F043.9060407@cox.net" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
On 1/8/2011 5:06 PM, Jürgen E. Fischer wrote:
<blockquote cite="mid:20110108230624.GA1344@norbit.de" type="cite">
<pre wrap="">On Sat, 08. Jan 2011 at 16:06:20 -0600, Byron Como wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 1/8/2011 3:15 PM, Jürgen E. Fischer wrote:
</pre>
</blockquote>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">So you have oids on the geometry table you try to insert, but QGIS is still
complaining?
</pre>
</blockquote>
</blockquote>
<blockquote type="cite">
<pre wrap="">That is correct.
</pre>
</blockquote>
<pre wrap="">Strange.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""> I deleted the 2.7 installation and installed 2.5 (see below).
</pre>
</blockquote>
</blockquote>
<pre wrap="">You don't need to install 2.5. You already installed it with QGIS, but having
other python installations should be a problem either.
</pre>
<blockquote type="cite">
<pre wrap="">My path statement is:
PATH=C:\OSGeo4W\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\OSGeo4W\apps\msys\bin
</pre>
</blockquote>
<pre wrap="">Where did you look that up? The system's PATH should be left alone by the
INSTALL. So you shouldn't have any "global" OSGeo4W entries there.
</pre>
</blockquote>
That came from path statement executed in the OSGeo4w console. The
path from the windows console doesn't have the OSGeo4W references.<br>
<blockquote cite="mid:20110108230624.GA1344@norbit.de" type="cite">
<blockquote type="cite">
<pre wrap=""> Try "import psycopg2" in the python console (or a python started from the
OSGeo4W shell). It's output might shed some light on the problem.
>>> import psycopg2
>>> psycopg2
<module 'psycopg2' from
'C:\OSGeo4W\apps\Python25\lib\site-packages\psycopg2\__init__.pyc'>
</pre>
</blockquote>
<pre wrap="">Hm, that looks fine - no idea why postgis manager is complaining.
Jürgen
</pre>
</blockquote>
La la la la la , I am happy, I ah happy, I am happy.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<br>
</body>
</html>