BUG #12650: user defined exception
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
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>:
Show quoted text
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
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.
Show quoted text
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