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.
- [PATCHES] Exception handling: Oracle's "SQLERRM" k... Dinesh Pandey