Обсуждение: Exception handling: Oracle's "SQLERRM" keyword option?

Поиск
Список
Период
Сортировка

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

От
"Dinesh Pandey"
Дата:

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?

От
Tom Lane
Дата:
"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