pl/pgsql exceptions

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pl/pgsql exceptions
Date: 2004-09-03 14:11:24
Message-ID: 20040903141124.24888.qmail@web41606.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way to retrieve the error code and error
message text when an exception has been caught via
"exception when others" in pl/pgsql? I'm looking
essentially for the equivalent of Oracle's pl/sql
sqlerrm and sqlcode variables.

Regards,

Shelby Cain



__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Wilson 2004-09-03 14:39:05 Re: "echo"ing a psql command in a bash script
Previous Message Lincoln Yeoh 2004-09-03 14:10:30 Re: postgres "on in the internet"