Re: BUG #12650: user defined exception

2015-01-24 11:29 GMT+01:00 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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(at)yahoo(dot)fr>:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 12650
>> Logged by: oussema
>> Email address: ousema2003(at)yahoo(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-bugs
>>
>
>