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

ODBC not reporting RI violations.

From: "Gene Sokolov" <hook(at)aktrad(dot)ru>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: ODBC not reporting RI violations.
Date: 2000-04-19 13:38:45
Message-ID: 13e801bfaa04$95bd5e70$0d8cdac3@aktrad.ru (view raw or flat)
Thread:
Lists: pgsql-interfaces
PGSQL 7.0beta5, freebsd 4.0
MS WinNT ODBC driver 6.50.00.00

Seems like there is a problem in the way RI violations are reported through
ODBC.

If I execute the following query in psql, I get an error (which is correct):

afmt=# INSERT INTO
Orders(AccNum,Type,OpenTS,RefPosition,ItemID,IsBuy,Lots,OrdPrice,StpPrice,Lm
tPrice,Expires)
VALUES(1,1,'19 Apr 2000 15:17:46',0,4,1,1,104.30,0.,0.,'20 Apr 2000
00:00:00');

ERROR:  <unnamed> referential integrity violation - key referenced from
orders not found in positions

But if the same query is executed through ODBC, the error is not reported,
the query just gets silently ignored. ODBC reports success, when in reality
the query was aborted.

All other errors are reported properly. This seems to be specific to RI
violations.

Gene Sokolov.




Responses

pgsql-interfaces by date

Next:From: Tom LaneDate: 2000-04-19 13:54:33
Subject: Re: getting OID of INSERTed record in ECPG
Previous:From: Guillaume RousseDate: 2000-04-19 12:03:38
Subject: RE: Is this usage correct ?

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