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 f5E6QAE91560
	for <pgsql-odbc@postgresql.org>; Thu, 14 Jun 2001 02:26:10 -0400 (EDT)
	(envelope-from Inoue@tpf.co.jp)
Received: (qmail 2597 invoked from network); 14 Jun 2001 06:26:06 -0000
Received: from unknown (HELO mcadnote1) (126.0.1.68)
	by sd2.10.0.100.in-addr.arpa with SMTP; 14 Jun 2001 06:26:06 -0000
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Zoltan Kovacs" <tip@pc10.radnoti-szeged.sulinet.hu>
Cc: "pgsql-odbc" <pgsql-odbc@postgresql.org>
Subject: Error handling in ODBC
Date: Thu, 14 Jun 2001 15:27:06 +0900
Message-ID: <EKEJJICOHDIEMGPNIFIJGEMEEKAA.Inoue@tpf.co.jp>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
In-Reply-To: <00042014060300.01312@tir>
Importance: Normal
X-Archive-Number: 200106/25
X-Sequence-Number: 578

Hi all,

Recently I found the case that  NOTICE causes an error in ODBC
while examining Kristis' error report.

It seems that NOTICE had never been the cause of SQL_ERROR
before Zoltan's change about a year ago. Before his change *NOTICE*
only caused a PGRES_NONFATAL_ERROR and SC_execute()
returned SQL_SUCCESS_WITH_INFO. However currently *ERROR*
also causes a PGRES_NONFATAL_ERROR and SC_Execute()
returns SQL_ERROR.
Why was this changed ?
I'd like to put it back if there's no reason.

regards,
Hiroshi Inoue