X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5125D6F4A for ; Thu, 20 Oct 2005 02:24:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80876-09 for ; Thu, 20 Oct 2005 05:24:32 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 1E8BEDA81C for ; Thu, 20 Oct 2005 02:24:26 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.11/8.12.11) with ESMTP id j9K5LLo8004159; Thu, 20 Oct 2005 10:51:21 +0530 Message-ID: <00b401c5d537$9503a9d0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Michael Fuhr" Cc: "postgre" References: <057401c5d497$a25e81e0$cd00000a@amiindiahjwbgh> <20051019172507.GA72974@winnie.fuhr.org> Subject: Re: Reg : Error Handling Date: Thu, 20 Oct 2005 10:30:36 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.047 required=5 tests=[AWL=-0.003, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/226 X-Sequence-Number: 19298 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" To: "sandhya" Cc: "postgre" 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