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 992BCDA661 for ; Wed, 19 Oct 2005 14:25:18 -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 74249-03 for ; Wed, 19 Oct 2005 17:25:16 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 5F169DA65E for ; Wed, 19 Oct 2005 14:25:16 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j9JHP9UG094700 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 19 Oct 2005 11:25:12 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id j9JHP9Vn073072; Wed, 19 Oct 2005 11:25:09 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id j9JHP7Pk073071; Wed, 19 Oct 2005 11:25:07 -0600 (MDT) (envelope-from mfuhr) Date: Wed, 19 Oct 2005 11:25:07 -0600 From: Michael Fuhr To: sandhya Cc: postgre Subject: Re: Reg : Error Handling Message-ID: <20051019172507.GA72974@winnie.fuhr.org> References: <057401c5d497$a25e81e0$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <057401c5d497$a25e81e0$cd00000a@amiindiahjwbgh> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/223 X-Sequence-Number: 19295 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