ODBC, Access and foreign key (part 2) - Mailing list pgsql-general

From J. 'FIK'Brand
Subject ODBC, Access and foreign key (part 2)
Date
Msg-id 91soml$iql$1@news.tht.net
Whole thread Raw
List pgsql-general
Here are the ODBC-log from the workstation and the log from the server.

ODBC-log :

MSACCESS        fffcb265-fffef419 ENTER SQLExecDirectW
  HSTMT               08592424
  WCHAR *             0x07D7AF60 [     126] "INSERT INTO c0011 VALUES
('WM4100340000',0,'23006000','410034',1,1,Null,39.31,0,Null,0,'STUKS',2,1,1,
0,0,0,'410034',Null,Null)"
  SDWORD                   126

MSACCESS        fffcb265-fffef419 EXIT  SQLExecDirectW  with return code 0
(SQL_SUCCESS)
  HSTMT               08592424
  WCHAR *             0x07D7AF60 [     126] "INSERT INTO c0011 VALUES
('WM4100340000',0,'23006000','410034',1,1,Null,39.31,0,Null,0,'STUKS',2,1,1,
0,0,0,'410034',Null,Null)"
  SDWORD                   126


Server-log

Dec 21 11:53:47 obelix logger: ERROR:  <unnamed> referential integrity
violation - key referenced from c0010 not found in c0030

Thanks Jurgen



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Best way to replicate a DB between two servers (master/slave)
Next
From: Jeff Eckermann
Date:
Subject: RE: Off topic? - Solution for a delimiter problem