Re: How to distinguish serialization errors from others using pqxx - Mailing list pgsql-general

From Kevin Grittner
Subject Re: How to distinguish serialization errors from others using pqxx
Date
Msg-id 1463342182.667235.1427224698227.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Re: How to distinguish serialization errors from others using pqxx  (Saimon <aimon.slim@gmail.com>)
List pgsql-general
Saimon <aimon.slim@gmail.com> wrote:

> As I undersand, the only way to determine serialization errors is
> to parse pqxx::sql_error exceptions' messages for keywords like
> "could not serialize" etc.

I had to do a web search to find out what pqxx was.  It is a C++
connector for PostgreSQL that's been around for ten years and most
recently released a new version two months ago.

http://pqxx.org/development/libpqxx/

From there it was pretty easy to find that making the SQLSTATE
available to the programmer is recognized as a desirable
enhancement, but has not yet been done:

http://pqxx.org/development/libpqxx/ticket/219

So I guess that leaves one parsing the text of the error messages
and hoping you know what language is going to be there.

Should pqxx be included in the table of externally maintained
client interfaces?:

http://www.postgresql.org/docs/current/static/external-interfaces.html

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Index corruption
Next
From: Kevin Grittner
Date:
Subject: Re: Index corruption