Re: error codes in postgresql

Hi sandhya,

You can use PQresultStatus API to get the result status of the command
execution

And PQresStatus to convert the enumerated type returned by
PQresultStatus to a string constant.

For more information you can check the libpq API documentation

http://www.postgresql.org/docs/8.0/static/libpq-exec.html
<http://www.postgresql.org/docs/8.0/static/libpq-exec.html>

Is this what you want?

Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of sandhya
Sent: Wednesday, August 17, 2005 3:49 PM
To: Tom Lane
Cc: Shashi Gireddy; postgre
Subject: [ADMIN] error codes in postgresql

Hi,

I want to know ,if there is any way to return error codes/numbers as a
return value from the postgresql functions.

For ex:

If i am using my connection function say,

DbConnect(dname,uname,.........)

{

//here i use postgres connection function

pg_conn *conn;

conninfo="dbname=example(dname) user=postgres(uname)";

conn=PQConnectdb(conninfo)

//After connecting i need to create a table..and if the table exists

PQerrormessage(conn) will return error message...

But what i need is ..

Is there any other way of returning error number to my main program.

Can you please tell me how to handle these errors in my application.

I referred posgresql site..I didn't get any clear idea of it.

Any help please......

Thank you...

Regards,

Sandhya R