number errors

Started by João Paulo Zavanelaover 18 years ago3 messagesgeneral
Jump to latest
#1João Paulo Zavanela
joao_zava@globo.com

Hi all,

When my application returns errors from database, some numbers errors is
equals.
Why number errors is equals? odbc driver or postgresql return this?

It's run in Windows.

Thanks.

#2Andrei Kovalevski
andyk@commandprompt.com
In reply to: João Paulo Zavanela (#1)
Re: number errors

Hello,

If you use ODBC - you should devide error from ODBC driver and errors
from PostgreSQL, ODBC driver return it's own error codes, and composes
error Description depending on Error Code and Text from PostgreSQL
server. So you should have numbers:
1) ODBC error code - described in MSDN;
2) Native PostgreSQL error code - described in PostgreSQL manual;
3) Error description - composed by ODBC driver, based on description and
error code, returned from server.

Joᅵo Paulo Zavanela wrote:

Show quoted text

Hi all,

When my application returns errors from database, some numbers errors is
equals.
Why number errors is equals? odbc driver or postgresql return this?

It's run in Windows.

Thanks.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#3João Paulo Zavanela
joao_zava@globo.com
In reply to: Andrei Kovalevski (#2)
Re: number errors

Hi all,

When my application returns errors from database, some numbers errors

is

equals.
Why number errors is equals? odbc driver or postgresql return this?

It's run in Windows.

Thanks.

Hello,

If you use ODBC - you should devide error from ODBC driver and errors
from PostgreSQL, ODBC driver return it's own error codes, and composes
error Description depending on Error Code and Text from PostgreSQL
server. So you should have numbers:
1) ODBC error code - described in MSDN;
2) Native PostgreSQL error code - described in PostgreSQL manual;
3) Error description - composed by ODBC driver, based on description and

error code, returned from server.

Hi,

Thanks for help.

I'm using ODBC Driver, so the ODBC driver returns the errors, ok?
So, this errors is independent from PostgreSQL server?