Thank you for the clarification. But why do i dont see the SQLSTATE code for Postgres as per my test on psql clients etc.
As its not showing the errorcode , thats the reason boto3 is not able to capture the error code.
Please advice if you have any thoughts on this as its confusing and developer thinks its some limitations on RDS side.
On Wednesday, February 17, 2021, bipsy Nair <nbipin29@gmail.com> wrote:
4. Test on Postgres with parameter ==> log_error_verbosity=verbose
SELECT name, setting FROM pg_settings WHERE name LIKE 'log_error_verbosity';
postgres=> create table bipin (id int);
ERROR: relation "bipin" already exists
postgres=> insert into bipin values(1);
ERROR: duplicate key value violates unique constraint "pk_error_logging" ==> NO SQL STATE captured.
DETAIL: Key (id)=(1) already exists.
That setting is for the log file, but you are showing what the client sees (which the server doesn’t really care about or influence - beyond client_min_message anyway).
But when i run the following it shows.
postgres=> \errverbose
ERROR: 23505: duplicate key value violates unique constraint "pk_error_logging"
Which proves the server is doing its job of sending back that data as specified in the protocol.
So we need a workaround wherein it can show the SQLSTATE code and want to know if its limitation at Postgres DB level.
No, its not a server limitation, its a client limitation - in this case boto3.
David J.