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: (view raw, whole thread or download thread mbox)
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

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


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-2017 The PostgreSQL Global Development Group