Postgres Pro
Downloads
Home   >   mailing lists

Re: [COMMITTERS] pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions are thrown if
Date
Msg-id 1050.1150494954@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [COMMITTERS] pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Plan B is to invent new errcodes to match the Oracle spellings.  If
>> that's what we want to do, it's not that hard.

> We could use:
>     #define ERRCODE_DATA_EXCEPTION              MAKE_SQLSTATE('2','2',
> or
>     #define ERRCODE_ERROR_IN_ASSIGNMENT         MAKE_SQLSTATE('2','2',

Those are both mighty generic (in fact DATA_EXCEPTION is a class code
not a specific error).  If we want to stick to existing errcodes I think
CARDINALITY_VIOLATION is the only reasonable choice.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump -Ft failed on Windows XP
Next
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Add STRICT to PL/pgSQL SELECT INTO, so exceptions