Re: BUG #12650: user defined exception - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #12650: user defined exception
Date
Msg-id CAFj8pRD97g_rREgYV6v2YrC2By3Y8QYkemxOiR=HoPg6aLyjeQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #12650: user defined exception  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-bugs
2015-01-24 11:29 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:

> Hi
>
> It is not a bug.
>
> For user defined exception should be reserved class 45 .. so you can use a
> SQLCODE 45***
>

and U0 class (U0***) should be reserved for custom exception too.


>
> Regards
>
> Pavel Stehule
>
> 2015-01-24 11:10 GMT+01:00 <ousema2003@yahoo.fr>:
>
>> The following bug has been logged on the website:
>>
>> Bug reference:      12650
>> Logged by:          oussema
>> Email address:      ousema2003@yahoo.fr
>> PostgreSQL version: 9.3.0
>> Operating system:   linux x86 64
>> Description:
>>
>> > what's the range of sqlstate that i can use for the user defined
>> exception
>> > e.g :
>> > In oracle the range is [20000..20999])
>> > so what's the similar one in postgresql
>>
>>
>> --
>> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>>
>
>

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #12650: user defined exception
Next
From: Tom Lane
Date:
Subject: Re: BUG #12644: Planner fails to use available index with anything other than default operator