Re: Cleaning up ERRCODE usage in our XML code

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-04-09T14:03:17Z
Lists: pgsql-hackers
Peter Eisentraut <peter@eisentraut.org> writes:
> On 14.09.24 21:14, Tom Lane wrote:
>> +Section: Class 10 - XQuery Error
>> +
>> +# recent SQL versions define quite a few codes in this class, but for now
>> +# we are only using this generic one
>> +10608    E    ERRCODE_INVALID_ARGUMENT_FOR_XQUERY                            invalid_argument_for_xquery

> Could you share what SQL standard document version you got this from?  I 
> don't see this particular code in any version I have.

I think I stole it from DB2:

10608	An error was encountered in the argument of an XQuery function or operator.

https://www.ibm.com/docs/en/db2-for-zos/12.0.0?topic=codes-sqlstate-values-common-error#db2z_sqlstatevalues__classcode10

If you feel motivated to replace that with some finer-grained codes,
it's OK by me.

			regards, tom lane



Commits

  1. Neaten up our choices of SQLSTATEs for XML-related errors.