agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Jürgen Purtz <juergen@purtz.de>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: SQL conformity regarding SQLSTATE
Date: Wed, 20 Dec 2017 20:28:15 -0500
Message-ID: <11558.1513819695@sss.pgh.pa.us> (raw)
In-Reply-To: <c5fb7c99-0f02-75cf-9b97-95693fc6adc7@purtz.de>
References: <c2c1a96d-dae9-6667-bf11-eb423ee90385@purtz.de>
<31999.1513697414@sss.pgh.pa.us>
<c5fb7c99-0f02-75cf-9b97-95693fc6adc7@purtz.de>
=?UTF-8?Q?J=c3=bcrgen_Purtz?= <juergen@purtz.de> writes:
> Summary: 01008, 03000, 0B000, 39001, F0000, and F0001 do not conform to
> the standard.
I poked around in SQL:2011 and I concur that the first four of those
no longer appear in the standard. However, unless grep is failing me,
we aren't generating those errcodes anywhere either:
ERRCODE_WARNING_IMPLICIT_ZERO_BIT_PADDING
ERRCODE_SQL_STATEMENT_NOT_YET_COMPLETE
ERRCODE_INVALID_TRANSACTION_INITIATION
ERRCODE_E_R_I_E_INVALID_SQLSTATE_RETURNED
So we could just remove those codes and be no worse off.
As for the other two, ERRCODE_CONFIG_FILE_ERROR and
ERRCODE_LOCK_FILE_EXISTS, we certainly are using those, but
as I mentioned it seems somewhat unlikely that clients are
testing for them. I'm tempted to propose renumbering them
as PF000 and PF001.
regards, tom lane
view thread (8+ messages) latest in thread
Message-ID: <11558.1513819695@sss.pgh.pa.us>
Permalink: ../11558.1513819695@sss.pgh.pa.us/
Also on: postgresql.org/message-id/11558.1513819695@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, juergen@purtz.de, pgsql-sql@lists.postgresql.org
Subject: Re: SQL conformity regarding SQLSTATE
In-Reply-To: <11558.1513819695@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox