EXCEPTION handling in PL/pgSQL.

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: EXCEPTION handling in PL/pgSQL.
Date: 2005-04-15 05:35:46
Message-ID: 20050415053841.262E353C7C@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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


Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-15 05:48:34 Re: row-attribute in EXPLAIN-output doesn't match count(*)
Previous Message Greg Stark 2005-04-15 05:25:08 Re: row-attribute in EXPLAIN-output doesn't match count(*)