Please advice on this issue. It points its a issue with Postgres which is not providing the SQLSTATE Error code.
I dug a bit deeper and found that the big library "psycopg2" interfaces directly with the Postgresql C lib (the major header being libpq-fe.h). Here is confirmation from that library's author:
https://github.com/psycopg/psycopg2/issues/1240
That being said, if all Botocore does is call AWS's internals to get a response, then chances are it's not a botocore issue.
The full boto logs show that the response from the request to http://internal.amazon.com/coral/com.amazon.rdsdataservice/ doesn't contain the SQLSTATE. This is what leads me to think that it's potentially a problem in the RDS Postgres internals.
Thank you,
Bipin
On Wednesday, February 17, 2021, bipsy Nair <nbipin29@gmail.com> wrote:
Thank you for the clarification. But why do i dont see the SQLSTATE code for Postgres as per my test on psql clients etc.
If you put psql into verbose mode, or do \errverbose, you see the error code. psql has, but chooses not to print, the error code in non-verbose mode.
David J.