Re: [HACKERS] error messages not only English

Yes, there is a preferred standard, it defines char(5) strings that correspond to specific errors.
It is in SQLSTATE in ESQL/C programs and conforms to X/Open and ANSI.
It consits of numbers and upper case letters only. The first 2 digits are the Class the, last 3
are the subclass. I think only the Class is in the norm.

e.g.: 02000 No data found or End of data reached
00000 Success.
0A000 Feature not supported

You get additional info through:
exec sql get diagnostics :num_rows_affected = ROW_COUNT [, :num = NUMBER, ...];

The integer SQLCODE + the sqlca structure is from an old ANSI norm:
0 Success
100 end of data
< 0 execution not successful
> 0 warning

Andreas
----------
Von: Vadim Mikheev[SMTP:vadim(at)krs(dot)ru]
Gesendet: Dienstag, 26. Mai 1998 18:43
An: Zeugswetter Andreas SARZ
Cc: 'hackers(at)postgresql(dot)org'; 'mimo(at)interdata(dot)com(dot)pl'
Betreff: Re: [HACKERS] error messages not only English

Andreas Zeugswetter wrote:
>
> Anyway, we are still missing the first step in this direction: enumerate ERROR messages.

BTW, are error codes in standard ?

Vadim