Re: How to distinguish serialization errors from others using pqxx

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Saimon <aimon(dot)slim(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to distinguish serialization errors from others using pqxx
Date: 2015-03-24 19:18:18
Message-ID: 1463342182.667235.1427224698227.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Saimon <aimon(dot)slim(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2015-03-24 19:47:02 Re: Index corruption
Previous Message John R Pierce 2015-03-24 19:16:07 Re: Index corruption