From: Dinesh Pandey <dpandey@secf.com>
To: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: EXCEPTION handling in PL/pgSQL.
Date: Fri, 15 Apr 2005 11:05:46 +0530
Message-ID: <20050415053841.262E353C7C@svr1.postgresql.org> (raw)
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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dpandey@secf.com
Subject: Re: EXCEPTION handling in PL/pgSQL.
In-Reply-To: <20050415053841.262E353C7C@svr1.postgresql.org>
* 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