Re: error codes in postgresql - Mailing list pgsql-admin
| From | Sivakumar K |
|---|---|
| Subject | Re: error codes in postgresql |
| Date | |
| Msg-id | 584DE893B0E08F4B9748E295029F1E9702C11415@maya.aztec.soft.net Whole thread Raw |
| In response to | error codes in postgresql ("sandhya" <sandhyar@amiindia.co.in>) |
| List | pgsql-admin |
-----Original Message-----
From: sandhya [mailto:sandhyar@amiindia.co.in]
Sent: Wednesday, August 17, 2005 6:16 PM
To: Sivakumar K
Cc: postgre; sandhya
Subject: Re: [ADMIN] error codes in postgresql
Thank you Sivakumar.
ExecStatusType PQresultStatus(const PGresult *res);
Will it return code or message.If i want to use this what should be the return value of my function?
This will return whether your query was executed successfully or not.
Onemore doubt..
char *PQresultErrorField(const PGresult *res, int fieldcode);
What is the use of this?What is the difference between the previous one and this?
PG_DIAG_SQLSTATE--If i use this as my fieldcode will it take care of all my error values.
Sorry for my basic questions.As i am very new to this i don't know how to handle errors in
this.
This will return more detailed info regarding why the query execution was not successful based on the fieldcode.
For example
If I execute select * from pg_databasesas (table does not exist)
PQresStatus (PQresultStatus (res)) will return PGRES_FATAL_ERROR
Whereas
PQresultErrorField (res, PG_DIAG_SQLSTATE) will return 42P01 which corresponds to "undefined table".
PQresultErrorField (res, PG_ DIAG_MESSAGE_PRIMARY) will return relation "pg_databasesa" does not exist.
Note that the above API's will return information regarding result set object only.
Normally we will be defining some errormessages according to the error codes return by the PQErrorMessage function.
I really wonder if PQErrorMessage returns error codes. AFAIK it returns error messages.
When i am using this even i declare my function as void..it is returning the errormessage.
So..what iam planning is if i have some error codes returning from any of my postgresql function i can define myown message for that and i can send it as a return value to the main right!
Please tell me how can i handle this?
Why do you want to define your own error messages when the appropriate error message is returned from PostgreSQL Server?
Please feel free to correct me
Thanks&Regards,
Sandhya
----- Original Message -----
From: Sivakumar K
To: sandhya
Cc: Shashi Gireddy ; postgre
Sent: Wednesday, August 17, 2005 5:49 PM
Subject: RE: [ADMIN] 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
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: