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

Lots of write errors with foreign key references :(

From: Mike Fahey <mfahey(at)enter(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Lots of write errors with foreign key references :(
Date: 2004-10-15 21:28:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
I'm using access 2003 and  snapshot 08.00.0001

When i try to do a simple insert query I get the error in access "write
conflict" this record has been changed by another user since....

Then the actual error from odbc is:

Error #7

Error: insert or update on table "category_products violates foreign key
constraint "$1"
(Source ODBC.database)

The query I'm trying to run works fine from a prompt.

Can someone look into this please?


With best regards,

Mike Fahey - Systems Administration
      ENTER.NET - "The Road to the Internet Starts Here!" (tm)
  (610) 437-2221 * * email:support(at)enter(dot)net

pgsql-odbc by date

Next:From: Rich SilvaDate: 2004-10-16 22:58:50
Subject: Errors compiling psqlodbc
Previous:From: Scot LoachDate: 2004-10-15 12:55:34
Subject: asynchronous queries?

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