[Qgis-user] Missing primary key. (SOLVED)

[Byron Como]

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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110108/d59e4e8e/attachment.html>