Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #12650: user defined exception

BUG #12650: user defined exception

From
ousema2003@yahoo.fr
Date:
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

Re: BUG #12650: user defined exception

From
Pavel Stehule
Date:
Hi

It is not a bug.

For user defined exception should be reserved class 45 .. so you can use a
SQLCODE 45***

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
>

Re: BUG #12650: user defined exception

From
Pavel Stehule
Date:
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
>>
>
>