pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sandhya <sandhyar@amiindia.co.in>
To: Michael Fuhr <mike@fuhr.org>
Cc: postgre <pgsql-admin@postgresql.org>
Subject: Re: Reg : Error Handling
Date: Thu, 20 Oct 2005 10:30:36 +0530
Message-ID: <00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh> (raw)
References: <057401c5d497$a25e81e0$cd00000a@amiindiahjwbgh>
	<20051019172507.GA72974@winnie.fuhr.org>

Reg stands for "regarding"

Error in the sence --->
I have a function to create a database and so on...... using libpqxx
library.
And i have a CLInterfacing program through which i can able to select option
which i want to do.
I am able to get the error messages if anything wrong i give......

But the errors are like below.
Say,If i have created a database called "sample" and when i try to give the
same database name to create againg it is displaying message like:
Database "sample" already exists-->Postgresql format
(Here the messages are Specific right)

What i want to manipulate is:
It should simply display
Database already exists --->Format i need
(The messages i need to display generally)

I am able to get the error code as a return value from the function using,
return (PQresultErrorField(res,PG_DIAG_SQLSTATE));
Problem is i don't know how to generalize the messages once i get
this....Pls any one help me in this regard

Thanks,
Sandhya



----- Original Message ----- 
From: "Michael Fuhr" <mike@fuhr.org>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "postgre" <pgsql-admin@postgresql.org>
Sent: Wednesday, October 19, 2005 10:55 PM
Subject: Re: [ADMIN] Reg : Error Handling


> On Wed, Oct 19, 2005 at 03:56:57PM +0530, sandhya wrote:
> > In error handling suppose if the database already exists..
> >
> > It is returning : database "sample(say)" doesn't exists.
>
> What is "it"?  What error handling are you talking about?  What are
> you doing that results in the error, and why does the error message
> (database doesn't exist) contradict what you first said (database
> already exists)?  Or is that part of what's puzzling you?  What
> does your query or function code (or whatever) look like, and what
> is the *exact* text of the error message?
>
> > If i want to return general error messages with out specifying names how
can i?
>
> Return error messages from where?
>
> > Tell me where can i get the error codes for this instead of
> > messages and how can i retrieve error no instead of printing message?
>
> Please tell us more about what you're doing and what problem you're
> trying to solve.  We don't have enough information to answer your
> questions without a lot of guessing.
>
> Incidentally, I notice that your Subject headers always begin with
> the word "Reg".  What's that about?  I've seen it a few other places
> but have never known what it meant.  Anybody?
>
> -- 
> Michael Fuhr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend




view thread (4+ messages)  latest in thread

Message-ID: <00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh>
Permalink:  ../00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh/
Also on:    postgresql.org/message-id/00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sandhyar@amiindia.co.in, mike@fuhr.org
  Subject: Re: Reg : Error Handling
  In-Reply-To: <00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh>
  References: <057401c5d497$a25e81e0$cd00000a@amiindiahjwbgh> <20051019172507.GA72974@winnie.fuhr.org> <00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox