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

Re: Error handling in ODBC

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: Tibor Laszlo <ltibor(at)mail(dot)tiszanet(dot)hu>, pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Error handling in ODBC
Date: 2001-06-18 15:29:52
Message-ID: Pine.LNX.4.21.0106181714260.29154-100000@pc10.radnoti-szeged.sulinet.hu (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
On Mon, 18 Jun 2001, Hiroshi Inoue wrote:

> > > Why was this changed ?

The truth is that I don't and didn't understand PostgreSQL internals when
I modified this part of the source. It worked for me and noone complained.

> > > I'd like to put it back if there's no reason.

Yes, of course.

> > I think it should be corrected. But if I rmember correctly, the patch was for
> > report RI violatoions to the app, and these errors comes as NOTICEs not ERRORs.
> > May I wrong? Is it the case now?

Tibor, the referential integrity messages come as 'E'rrors, not
'N'otices:

ERROR:  <unnamed> referential integrity violation - key in
X still referenced from Y

> I don't know how it came about. ISTM the old driver didn't
> take 'E' after 'C' response into account and failed to report
> RI violation errors by ignoring the 'E'.  The 'E' correponds
> to an ERROR not a NOTICE.

IIRC, the reference integrity error reporting didn't work because the
server had some different protocol in sending those letters. In other 
words, the driver didn't handle this type of message well. You may 
almost certainly put back the old code but please check this
part if it is not corrected yet.

Regards, Zoltan


In response to

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2001-06-18 16:56:13
Subject: Re: Error handling in ODBC
Previous:From: Frimann VestrheimDate: 2001-06-18 13:52:05
Subject: Download of ODBC driver

pgsql-interfaces by date

Next:From: Hiroshi InoueDate: 2001-06-19 00:11:11
Subject: Re: Error handling in ODBC
Previous:From: Hiroshi InoueDate: 2001-06-18 00:58:49
Subject: Re: Error handling in ODBC

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