From: | Kristis Makris <kristis(dot)makris(at)datasoft(dot)com> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Error messages not always reported through the ODBC driver -STATEMENT ERROR missing |
Date: | 2001-08-24 16:45:23 |
Message-ID: | 200108241645.f7OGjNf32920@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello Again,
> > conn=33461048, query='BEGIN'
> > conn=33461048, query='SELECT Vendor_Remove(1)'
> > [ fetched 1 rows ]
> > conn=33461048, query='COMMIT'
> > ERROR from backend during send_query: 'ERROR: <unnamed> referential
> > integrity violation - key in vendor still referenced from
> > vendorforwellagreement'
> > CONN ERROR: func=SQLTransact, desc='', errnum=110, errmsg='ERROR:
>
> The error seems to have occured at SQLTransact().
> Probbably you should catch the error at CommitTrans() not at
> ExecuteSQL().
>
I've also tried the following from the psql command-line client:
******************************************************************************************
wats=# begin;
BEGIN
wats=# select vendor_remove(1);
ERROR: <unnamed> referential integrity violation - key in vendor still
referenced from vendorforwellagreement
wats=# commit;
COMMIT
******************************************************************************************
psql reports the error when I issue the SELECT statement, not when I
issue the commit. Shouldn't I be able to capture an exception when I do
an ExecuteSQL() from VC++, instead of a CommitTrans() ?
Thanks,
-Kristis
---------------------------------------------------------------------
Kristis Makris Datasoft Corporation
kristis(dot)makris(at)datasoft(dot)com http://www.datasoft.com
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Contejean, TiJana | 2001-08-24 21:01:34 | pgAdmin/ODBC errors. |
Previous Message | Hiroshi Inoue | 2001-08-24 16:40:53 | RE: ODBC include files |