[Qgis-user] Missing primary key.

[Jürgen E. Fischer]

[please keep the thread on the list.  And if you want to do me a favor, use
plain text and reply inline]

Hi Byron,

On Sat, 08. Jan 2011 at 11:30:22 -0600, Byron Como wrote:
> On 1/8/2011 11:19 AM, Jürgen E. Fischer wrote:
> >  Maybe you had oids before?

> Nope, only the geometry table uses oids. The data tables all have gid,
> ineger, as the primary key. In pgadmin the data can be manipulated normally -
> copied, pasted, deleted and all the columns are correct.

So you have oids on the geometry table you try to insert, but QGIS is still
complaining?
 
> The data was created on Windows Xp, Postgresql 8.4, Quantum GIS 1.5.  Several
> times the data had to be restored to the Windows XP setup for various reasons
> including a lightning strike. The restore process worked correctly each time.
> The current broken setup is on a Windows 7 box, Postgresql 8.4, PostGIS 1.4,
> and Quantum GIS 1.5 and 1.6 have been tried.

On Sat, 08. Jan 2011 at 14:37:27 -0600, Byron Como wrote:
> On 1/8/2011 2:29 PM, Jürgen E. Fischer wrote:
> > The python included in the standalone installer should work.  Are you
> > trying to make it use your python 2.7 installation?  If so, that might
> > cause the problem.

> Ah, here's where the whole episode gets murky. The error message occurred
> after installing using the 'simplified' installer - before I installed any
> extra python software. I decided to install the extra python and psycopg2
> packages after failing to find any good suggestions on resolving the
> problem searching Google. Your feed back is helpful. Now I know I don't
> need the extra python packages. Then is the problem an evironment variable
> setting?
 
Do you have PostgreSQL installed locally?  Were PostgreSQL directories added to
the PATH or installed in %WINDIR%\system32.  That might interfere.

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.

Maybe it's not just a python problem and is somehow related to the primary key
problem.


Jürgen 

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-20
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502