From: | "Tibor Laszlo" <ltibor(at)mail(dot)tiszanet(dot)hu> |
---|---|
To: | "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org> |
Cc: | Kov當s Zolt疣 <kovzol(at)math(dot)u-szeged(dot)hu> |
Subject: | RE: Error handling in ODBC |
Date: | 2001-06-16 15:48:49 |
Message-ID: | NEBBJDDFALKDHFBLCGCPCEJCCBAA.ltibor@mail.tiszanet.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-odbc |
Hiroshi Inoue writes:
> 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 ?
Zoltan changed the driver because nobody else did it. As I recall, we asked this
list to correct the driver to work correctly with 7.0 pre releases with RI, but
we received no answers. We tried to correct the problem for ouselves. It worked.
But later we were asked to share the patch. Lastly it used to commit the main
CVS by sombody else but we asked this list again to werify the modifycatons by
sombody knowing something about ODBC and the current driver.
> I'd like to put it back if there's no reason.
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?
We still use the old patched driver. (It says "(non fatal)" error this case in
the error message - may the shared patch says it too.)
In addition later we encountered the same problem as you... And Zoltan made his
second patch, against the backend to do not drop other NOTICE-s :-) And it works
fine too... :-)) Is somebody interested in? :-)))
Regards,
Tibor Laszlo
ltibor(at)mail(dot)tiszanet(dot)hu
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Grenda | 2001-06-17 12:12:55 | jbuilder and postgres |
Previous Message | Peter Eisentraut | 2001-06-16 12:49:41 | Re: NULL feilds and ERROR messages from libpq++ |
From | Date | Subject | |
---|---|---|---|
Next Message | rkrk | 2001-06-16 21:36:02 | how to get odbc on postgresql 7.1 |
Previous Message | Dariusz Pietrzak | 2001-06-16 13:44:14 | Re: row versioning. |