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

Started by Dinesh Pandeyalmost 21 years ago2 messagesgeneral

dpandey@secf.com

almost 21 years ago

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

tgl@sss.pgh.pa.us

almost 21 years ago

In reply to: Dinesh Pandey (#1)

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

"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