| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
| Cc: | Neil Conway <neilc(at)samurai(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-committers(at)postgresql(dot)org |
| Subject: | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support |
| Date: | 2005-06-02 15:01:56 |
| Message-ID: | 13986.1117724516@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-patches |
Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> writes:
> On Thu, 2 Jun 2005, Tom Lane wrote:
>> The results of Pavel's experiments prove that Oracle's behavior is
>> pretty random --- it looks to me like the chance results of whatever
> What I can speek. Oracle has session variable for saving err code of last
> exception. On the start of session is zero. After executing any EXCEPTION
> BLOCK is this session zeroed. I can't to see so it's buggy behavior.
Well, it may not be strictly a "bug", but it's certainly a very poor
design, since it fails to cope at all nicely with nested-exception cases.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2005-06-02 15:05:31 | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support |
| Previous Message | Pavel Stehule | 2005-06-02 14:58:29 | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2005-06-02 15:05:31 | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support |
| Previous Message | Pavel Stehule | 2005-06-02 14:58:29 | Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support |