Re: error codes in postgresql - Mailing list pgsql-admin

From Sivakumar K
Subject Re: error codes in postgresql
Date
Msg-id 584DE893B0E08F4B9748E295029F1E9702C1114A@maya.aztec.soft.net
Whole thread Raw
In response to error codes in postgresql  ("sandhya" <sandhyar@amiindia.co.in>)
List pgsql-admin

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

 

      Is this what you want?

 

 

Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.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

 

 

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: error numbers in postgresql
Next
From: "sandhya"
Date:
Subject: Re: error codes in postgresql