Re: Unrecognized exception condition "deprecated_feature"

On Fri, Mar 9, 2018 at 11:55 AM, Kouber Saparev <kouber(at)gmail(dot)com> wrote:

> For some reason using an error code of 'deprecated_feature' does not work,
> while its equivalent '01P01' works just fine.
>
> kouber=# DO $$
> BEGIN
> RAISE WARNING 'Deprecated'
> USING ERRCODE = 'deprecated_feature';
> END;
> $$;
> ERROR: unrecognized exception condition "deprecated_feature"
> CONTEXT: PL/pgSQL function inline_code_block line 3 at RAISE
>
> kouber=# DO $$
> BEGIN
> RAISE WARNING 'Deprecated'
> USING ERRCODE = '01P01';
>
> ​[...]​

> kouber(at)spectre:~/src/postgres$ grep -r deprecated_feature .
>
> ./src/backend/utils/errcodes.txt:01P01 W ERRCODE_WARNING_DEPRECATED_FEATURE
> deprecated_feature
>
> I am using PostgreSQL 10.1, I apologize in case it has already been fixed
> in 10.2 or 10.3.
>

​While I haven't looked at the source code or docs for this I'm wondering
why you believe this is a bug in the first place. If "01P01" is a valid
and expected value for ERRCODE I would expect that the textual string label
representing it would not be.​ The two are not likely to be
interchangeable. Have you found working code where this is does work as
you expect?

David J.