Skip site navigation (1) Skip section navigation (2)

Re: Problem inserting with remote views in vfp

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: "Geoffrey Clements" <geoff(at)electron(dot)me(dot)uk>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problem inserting with remote views in vfp
Date: 2006-04-21 21:51:09
Message-ID: 8511B4970E0D124898E973DF496F9B43251595@stash.stackdump.local (view raw or flat)
Thread:
Lists: pgsql-odbc
I recommend that you turn logging on either on the ODBC side or on the server side, and see exactly what you are sending as a query.
Also, try to send the exact query you would be making from your applicatio via PSQL or pgAdmin and see the results.
Browsing a table is not fgoing to trigger a constraint.  This will happen only if you are inserting/updating/deleting rows.


-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Geoffrey Clements
Sent: Friday, April 21, 2006 3:29 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Problem inserting with remote views in vfp


I'm in the process of converting a Visual FoxPro application from using local 
tables to using a postgresql backend on a Debian box with psqlODBC on Windows 
Xp.

I've set up the database server with the necessary tables containing test data 
and using a remote view in VFP I can browse and update data.  However when I 
insert a row into the view and try to commit the change to the server I get 
an error message saying that the null value for the primary key conflicts 
with the non-null constraint, however the data that I am inserting is 
non-null for the primary key.

Any help would be appreciated as I've run out of ideas on how to fix this.

-- 
Geoff                                           Registered Linux user 196308

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-odbc by date

Next:From: Andrew NgDate: 2006-04-24 10:38:21
Subject: Re: Support for PostgreSQL 8.1.3 stable
Previous:From: Geoffrey ClementsDate: 2006-04-21 21:28:55
Subject: Problem inserting with remote views in vfp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group