How to restrict who may read my entries?
error codes in postgresql
Hello Guest		   
  • Login
• Register…
• Start blog		   • Who, Where, When
• What can I do?
• What to Read?		   • Polls
• Avatars
• Interests		   • Cities and Countries
• Random blog
• Users search		   • Search
• Games
• Tests
• QAIX		   • Сообщества
• Talxy Chat
• Horoscope
• Online		  
Зарегистрируйся!
QAIX > PostgreSQL database development > error codes in postgresql 17 June 2008 19:32:12
  Recent blog posts: 
Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded&helli­p;

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded&helli­p;

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

  They have birthday today: 
xiongchong
henna diah
  Forums:   
    topic feeds

• QAIX  all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous
  Discuss: 
plpgsql - Insert from a record…
Dear Postgresql experts, I'm writing a simple plpgsql function that selects a row from a table…

calling a pl/pgsql function…
Hello, i am tryin to pass an array like argument to a pl/pgsql function but i can not find the correct…

PgDatabase, on heap…
I am having a problem constructing a PgDatabase object. If I create the object on the stack (as a var…

Backup and restore through JDBC
Hello List I am trying to develop, a API to carry through backup and restore through JDBC. I think that…
  Recent forum topics: 
why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/­Ticket/Display.html?­id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…
  Recent forum comments:
RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@n­ospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.in­etserver.asp.general­: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.­net> wrote: Using…
  Moderators:
 Administrator
 Protorioris

error codes in postgresql

Sandhya 17 June 2008 19:32:12
 

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,una­me,.........)
{
//here i use postgres connection function
pg_conn *conn;
conninfo="dbname=ex­ample(dname) user=postgres(uname­)";
conn=PQConnectdb(co­nninfo)
//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

Add comment
Sivakumar K 17 August 2005 16:19:30 [ permanent link ]
 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.postgres­ql.org/docs/8.0/stat­ic/libpq-exec.html
<http://www.postgre­sql.org/docs/8.0/sta­tic/libpq-exec.html>­



Is this what you want?





Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-admin-owner@p­ostgresql.org
[mailto:p­gsql-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,una­me,.........)

{

//here i use postgres connection function

pg_conn *conn;

conninfo="dbname=ex­ample(dname) user=postgres(uname­)";

conn=PQConnectdb(co­nninfo)

//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





Add comment
Sandhya 17 August 2005 16:46:01 [ permanent link ]
 Thank you Sivakumar.
ExecStatusType PQresultStatus(cons­t PGresult *res);
Will it return code or message.If i want to use this what should be the return value of my function?

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--I­f 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.
Normally we will be defining some errormessages according to the error codes return by the PQErrorMessage function.
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?

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.postgres­ql.org/docs/8.0/stat­ic/libpq-exec.html



Is this what you want?





Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-admin-owner@p­ostgresql.org [mailto:p­gsql-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,una­me,.........)

{

//here i use postgres connection function

pg_conn *conn;

conninfo="dbname=ex­ample(dname) user=postgres(uname­)";

conn=PQConnectdb(co­nninfo)

//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




Add comment
Sivakumar K 17 August 2005 18:03:21 [ permanent link ]
 -----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(cons­t 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--I­f 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_PRIMAR­Y) 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 <mailto:sivakumark@­aztec.soft.net> K

To: sandhya <mailto:sandhyar@am­iindia.co.in>

Cc: Shashi Gireddy <mailto:gireddy@gma­il.com> ; postgre
<mailto:p­gsql-admin­@postgresql.org>

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.postgres­ql.org/docs/8.0/stat­ic/libpq-exec.html
<http://www.postgre­sql.org/docs/8.0/sta­tic/libpq-exec.html>­



Is this what you want?





Regards,

Siva Kumar.K

-----Original Message-----
From: pgsql-admin-owner@p­ostgresql.org
<mailto:p­gsql-admin­-owner@postgresql.or­g>
[mailto:p­gsql-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,una­me,.........)

{

//here i use postgres connection function

pg_conn *conn;

conninfo="dbname=ex­ample(dname) user=postgres(uname­)";

conn=PQConnectdb(co­nninfo)

//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





Add comment
Sivakumar K 23 August 2005 08:24:38 [ permanent link ]
 

Hi sandhya,

I really wonder if the function name is pg_field_type (res,
col_no).

The function name which returns the field type of a particular column is
PQftype (res, col_no).

This returns the field type as oid.The oid of the built-in data types
can be found in src/include/catalog­/pg_type.h



When using libpq API's you need to include only "libpq-fe.h".





Is pg_field_type (res, col_no) an abstraction over PQftype (res, col_no)
in your case?



Regards,

Siva Kumar.K







-----Original Message-----
From: sandhya [mailto:sandhyar@amiindia.co.in]
Sent: Monday, August 22, 2005 7:12 PM
To: Sivakumar K
Cc: postgre; sandhya
Subject: Re: [ADMIN] error codes in postgresql



Hi,

I have one doubt,



Inorder to get the field type in a table i am using
pg_field_type(res,c­ol_no)



Col_no : Is the field no. for which i have to know the field type.



When i am using the above declaration, i am getting the error as,

pg_field_type undeclared(First use this function)



What i have to include?

I am unable to get.Pls Help me.

I have included 'libpq-fe.h".Othert­han this what i should include.

Pls help me in this regard,



Thanks&Regards,

Sandhya R





Add comment
madhtr 10 May 2007 18:38:34 [ permanent link ]
 
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

This person does not want error strings, they want error numbers. And the reasoning is simple. you can fall through a case block in c++ much more efficiently with numbers than by doing an if else if structure with string comparisons. string comparisons waste alot of cycles and memory, and should only be used to communicate with the user.
Add comment
Guest 17 June 2008 18:56:18 [ permanent link ]
 hey if u not interested, dont visit this page.... dont comment others... =^B­
Never mind Sandhya ...
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

QAIX > PostgreSQL database development > error codes in postgresql 17 June 2008 19:32:12
see also:
Bug(?) in quotes and \ escaping
checking for tables
Online payment services??? What to use?
пройди тесты:
see also:
How to convert DVD Video to iPhone 3G
How to convert DVD movie, video…
How to Enjoy…
  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .