Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f5J2Kra87907
	for <pgsql-odbc@postgresql.org>; Mon, 18 Jun 2001 22:20:54 -0400 (EDT)
	(envelope-from Inoue@tpf.co.jp)
Received: (qmail 15234 invoked from network); 19 Jun 2001 02:20:46 -0000
Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108)
	by sd2.10.0.100.in-addr.arpa with SMTP; 19 Jun 2001 02:20:46 -0000
Received: from tpf.co.jp ([126.0.1.68])
	by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id LAA27471;
	Tue, 19 Jun 2001 11:20:44 +0900 (JST)
Message-ID: <3B2EB73D.7300385F@tpf.co.jp>
Date: Tue, 19 Jun 2001 11:21:49 +0900
From: Hiroshi Inoue <Inoue@tpf.co.jp>
X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U)
X-Accept-Language: ja
MIME-Version: 1.0
To: Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>,
	Tibor Laszlo <ltibor@mail.tiszanet.hu>,
	Dave Page <dpage@vale-housing.co.uk>,
	Kristis Makris <kristis.makris@datasoft.com>,
	Mister ics <mister_ics@hotmail.com>
CC: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: Re: Error handling in ODBC
References: 
 <Pine.LNX.4.21.0106181714260.29154-100000@pc10.radnoti-szeged.sulinet.hu>
	<3B2E989F.D68C5955@tpf.co.jp>
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200106/63
X-Sequence-Number: 616

Hi all,

I've just committed a fix to cvs.

Changed the error handling as follows.
1) ERRORs causes an SQL_ERROR and the SQLSTATE='S1000'.
2) NOTICEs causes an SQL_SUCCESS_WITH_INFO and the succeeding
   SQLError() returns the NOTICE message.

Remarks.
1) RI violation ERRORs are reported properly.
2) The NOTICE is the last NOTICE message and
   is truncated to 4095 bytes.

regards,
Hiroshi Inoue