Postgres Pro
Downloads
Home   >   mailing lists

EXCEPTION handling in PL/pgSQL. - Mailing list pgsql-sql

From Dinesh Pandey
Subject EXCEPTION handling in PL/pgSQL.
Date
Msg-id 20050415053841.262E353C7C@svr1.postgresql.org
Whole thread Raw
List pgsql-sql
Tree view
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

 

pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)
Next
From: Tom Lane
Date:
Subject: Re: row-attribute in EXPLAIN-output doesn't match count(*)