X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 731C153BEB for ; Fri, 15 Apr 2005 02:38:47 -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 66598-06 for ; Fri, 15 Apr 2005 05:38:42 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 262E353C7C for ; Fri, 15 Apr 2005 02:38:41 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000636967.msg for ; Thu, 14 Apr 2005 22:39:03 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: EXCEPTION handling in PL/pgSQL. Date: Fri, 15 Apr 2005 11:05:46 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C541AB.14F48770" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVBfPkM6/9hPSL/Ru2fihP2J3LoEg== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Thu, 14 Apr 2005 22:39:03 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Thu, 14 Apr 2005 22:39:06 -0700 Message-Id: <20050415053841.262E353C7C@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.398 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200504/217 X-Sequence-Number: 21110 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C541AB.14F48770 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am new in Postgres. Can any one tell me best way of EXCEPTION handling in PL/pgSQL. 1. I mean How to get Raised Exception messages in "EXCEPTION" block (I mean exception messages thrown by us OR by Postgres SQL Exception). 2. Is EXCEPTION datatype is available in Postgres as it is available in ORACLE. Regards Dinesh Pandey ---------------------------------------------------------------------------- ------ Dinesh Pandey Sr. Software Engineer ------=_NextPart_000_0019_01C541AB.14F48770 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I am = new in=20 Postgres.

Can = any one tell me=20 best way of EXCEPTION handling in PL/pgSQL.

1. I = mean How to get=20 Raised Exception messages in "EXCEPTION" block (I mean exception = messages thrown=20 by us OR by Postgres SQL Exception).

2. Is = EXCEPTION=20 datatype is available in Postgres as it is available in=20 ORACLE.

Regards
Dinesh Pandey

----------------------------------------------------------------= ------------------
Dinesh Pandey
Sr. Software = Engineer

------=_NextPart_000_0019_01C541AB.14F48770--