Problem with API (libpq) - detailed error codes - Mailing list pgsql-general

From Adam.Bukla@interia.pl (Adam Bukla)
Subject Problem with API (libpq) - detailed error codes
Date
Msg-id d07b23e8.0401300717.5ebb53b1@posting.google.com
Whole thread Raw
Responses Re: Problem with API (libpq) - detailed error codes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi!

I started programming PostgreSQL database with libpq API (client
side). It looks very easy, but unexpected I found problem, which I
cannot solve myself.
If function PQexec fails, I can get error code using PQresultStatus.
But returned codes are very generally and do not specify what really
happen. I can get detailed error description using PQerrorMessage
function, but I need detailed error code (number).

For instance, if I create table, I would like to know, that operation
failed because:
- table already exist
- sql syntax error
- invalid columnt type
and so on.

I searched documents about libpq API and even header file
'internal/libpq-int.h' but I didn't found any interesting.

I would be very gracefully for any hint.

Best regards,
Adam Bukla

pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Unicode vs SQL_ASCII DBs
Next
From: Louis LeBlanc
Date:
Subject: Re: Large object insert/update and oid use