Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > If we go with that how does the caller check between not found and too
> > many? And if we go with Oracle names, I need different codes to match
> > with the two Oracle names.
>
> I think we should just go with two new codes and use the Oracle names
> for them. One remaining question: shall we assign codes in class 21
> (Cardinality Violation) or class P0 (PL/pgSQL Error)? If you think
> these are likely to be used in other places then class 21 seems
> reasonable, but if we are thinking of them as being Oracle compatibility
> hacks then I'd lean to class P0.
Oracle-only, I would think, but I am no Oracle expert (never used it,
actually (a badge of honor?)).
> Actually ... does Oracle have SQLSTATEs assigned to these errors?
> If so, maybe we should use theirs. I had the idea they were still
> stuck on non-spec-compatible error numbers, though.
Anyone?
-- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
