SEO

#1 (**permalink**) 04-09-2008, 09:01 AM

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/s...-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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#2 (**permalink**) 04-09-2008, 09:06 AM

On Mar 29, 2006, at 11:13 AM, Emi Lu wrote:
> I found errorcodes info here:
> http://www.postgresql.org/docs/8.1/s...-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?

Unfortunately I suspect the only answer is "the source code". Any
improved documentation you could provide would be most welcome.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Getting more information about errorcodes such as when these error1happen