Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> writes:
> Is there any way to get the last SQLSTATE from the connection object
> or is that information lost?
This was discussed just a few days ago:
https://www.postgresql.org/message-id/flat/125437e5-25c8-49ad-99af-8de04b77daf6%40postgrespro.ru
I'd be in favor of adding some API here as long as it's not
myopic about the complexity of the problem.
regards, tom lane