Postgres Pro
Downloads
Home   >   mailing lists

Thread: Exception handling: Oracle's "SQLERRM" keyword option?

Exception handling: Oracle's "SQLERRM" keyword option?

From
"Dinesh Pandey"
Date:

Hi,

 

I have installed PostgreSQL 8.0.1 on Solaris 9.

 

I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL language.

 

In Oracle we can get error message from "SQLERRM" keyword and insert messages into log table.

 

How can I get error message/error code in PostgreSQL after an EXCEPTION or RAISE EXCEPTION occurs in EXCEPTION block??

 

Pls help me or send me some example.

 

 

Thanks

Dinesh Pandey 

 

 

Re: Exception handling: Oracle's "SQLERRM" keyword option?

From
Tom Lane
Date:
"Dinesh Pandey" <dpandey@secf.com> writes:
> Pls help me or send me some example.

Please do not post requests for help on pgsql-patches ... there is no
Postgres list on which they are further off-topic.

            regards, tom lane