Re: BUG #16868: Cannot find sqlstat error codes.

On Tue, Feb 16, 2021, at 12:21 PM, bipsy Nair wrote:

postgres=# \i /tmp/b16868.sql

DROP TABLE

CREATE TABLE

INSERT 0 1000

ALTER TABLE

psql:/tmp/b16868.sql:19: ERROR:  duplicate key value violates unique constraint "pk_error_logging"

DETAIL:  Key (id)=(1) already exists.

postgres=# \errverbose

ERROR:  23505: duplicate key value violates unique constraint "pk_error_logging"

DETAIL:  Key (id)=(1) already exists.

SCHEMA NAME:  public

TABLE NAME:  bipin

CONSTRAINT NAME:  pk_error_logging

LOCATION:  _bt_check_unique, nbtinsert.c:656

The sqlstate (23505) is reported accordingly. Since you are using Aurora and it

is not Postgres, it should possibly omit the sqlstate in the error message stack.    

The other possibility is that aurora-data-api is not gathering the sqlstate.      

I'm afraid you won't find both answers here.