Re: More on elog and error codes - Mailing list pgsql-hackers

From Gunnar R|nning
Subject Re: More on elog and error codes
Date
Msg-id x6bsqw1rv8.fsf@thor.candleweb.no
Whole thread Raw
In response to More on elog and error codes  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:

> > So we need some good error numbering scheme.  Any ideas?
> 
> SQL9x specifies some error codes, with no particular numbering scheme
> other than negative numbers indicate a problem afaicr.
> 
> Shouldn't we map to those where possible?
> 

Good point, but I guess most of the errors produced are pgsql
specific. If I remember right Sybase had several different SQL types of error
mapped to one of the standard error codes. 

Also the JDBC API provides methods to look at the database dependent error
code and standard error code. I've found both useful when working with
Sybase. 

cheers, 
Gunnar


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Re: elog with automatic file, line, and function
Next
From: Tom Lane
Date:
Subject: Re: AW: Re: elog with automatic file, line, and function