Re: Anybody have an Oracle PL/SQL reference at hand? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Anybody have an Oracle PL/SQL reference at hand?
Date
Msg-id 17371.1091496269@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anybody have an Oracle PL/SQL reference at hand?  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Anybody have an Oracle PL/SQL reference at hand?
Re: Anybody have an Oracle PL/SQL reference at hand?
Re: Anybody have an Oracle PL/SQL reference at hand?
List pgsql-hackers
"Jim C. Nasby" <decibel@decibel.org> writes:
> Oracle defines very few named exceptions. Instead, the intention is that
> you define a name for a numeric exception and use it yourself.

Yeah, I noticed that.  It seems a spectacularly bad idea :-(.  What
redeeming social value has it got?  AFAICS there are no upsides, only
downsides: you might get the numeric code wrong, and never know it
until your code fails in the field; and even if you always get it
right, having every bit of code invent its own random name for the
same exception doesn't seem like it does anything for readability or
maintainability.

In any case we use SQLSTATEs not SQLCODEs, so we have no hope of being
compatible with Oracle at that level.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Open items
Next
From: Christopher Kings-Lynne
Date:
Subject: How to crash postgres using savepoints