ODBC, Access and foreign key (part 2)

From: "J(dot) 'FIK'Brand" <jurgen(dot)brand(at)tip(dot)nl>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC, Access and foreign key (part 2)
Date: 2000-12-21 11:16:17
Message-ID: 91soml$iql$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

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

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2000-12-21 11:18:55 Re: Best way to replicate a DB between two servers (master/slave)
Previous Message Alessio Bragadini 2000-12-21 09:46:33 red hat/mysql fiasco

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 2000-12-21 15:18:20 Problems with int8 and MS ADO/ODBC
Previous Message Bernard ISAMBERT 2000-12-21 11:05:42 Problem with ecpg and 7.1beta1