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.
Thanks to all that responded. Happy New Year. I'll go back to my dark
little room now and be quiet.
On 1/8/2011 5:16 PM, Byron Como wrote:
On 1/8/2011 5:06 PM, Jürgen E. Fischer wrote:
On Sat, 08. Jan 2011 at 16:06:20 -0600, Byron Como wrote:
On 1/8/2011 3:15 PM, Jürgen E. Fischer wrote:
So you have oids on the geometry table you try to insert, but QGIS is still
complaining?
That is correct.
Strange.
I deleted the 2.7 installation and installed 2.5 (see below).
You don't need to install 2.5. You already installed it with QGIS, but having
other python installations should be a problem either.
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
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.
That came from path statement executed in the OSGeo4w console. The
path from the windows console doesn't have the OSGeo4W references.
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'>
Hm, that looks fine - no idea why postgis manager is complaining.
Jürgen
La la la la la , I am happy, I ah happy, I am happy.
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
