Message-ID: <442ABE69.4030703@encs.concordia.ca>
Date: Wed, 29 Mar 2006 12:05:45 -0500
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Getting more information about errorcodes such as when these error1
	happen
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Good morning,

In my plpgsql functions I use "exception when..." to catch possible 
exceptions of my data. I found postgresql error code track functions are 
very helpful.  In my functions, I will not catch all error codes, but 
only the ones applying to my data operation .

I found errorcodes info here:
http://www.postgresql.org/docs/8.1/static/errcodes-appendix.html

But I am afraid that I could not imagine when and under what possible 
circumstances some errorcodes may happen just by their names such as : 
locator_exception, invalid_grantor,  active_sql_transaction , and so on.

I tried to search the online docs in order to get more info such as when 
will errorcode X happens. But I could not find it.

Could someone tell me some links that I can find more information about 
these errorcodes please?

Thanks alot,
Ying